My CurrentTime() Format is coming up 10:12:15 AM AM, and I would like to change it. How do I change this? Also my date format in my SQL is coming up { d, ‘1998-21-10’}, the database date Format is ‘YYYY-DD-MM’, where is this translated if at all to the Database Format. If it is not where can I change this? I checked the .prm file but there is nothing for Date. FYI I am using BO 4.1.2 on DB2 MVS.
Thanks,
DebraAnn Braun
Frito-Lay, Inc.
Listserv Archives (BOB member since 2002-06-25)
[My CurrentTime() Format is coming up 10:12:15 AM AM, and I would like to change it. How do I change this? Also my date format in my SQL is coming up { d, ‘1998-21-10’}, the database date Format is ‘YYYY-DD-MM’, where is this translated if at all to the Database Format. If it is not where can I change this? I checked the .prm file but there is nothing for Date. FYI I am using BO 4.1.2 on DB2 MVS.]
Sorry I answered my own quesiton on the InputDateFormat issue but I am still unsure of the Time issue. I checked my regional settings for time but I cannot determine why the AM (or PM) is showing double???
Listserv Archives (BOB member since 2002-06-25)