I have a datetime "POSTING_DTTM" field and when I view the mysql statement that peoplesoft query automatically creates it has SELECT TO_CHAR(POSTING_DTTM,'YYYY-MM-DD-HH24.MI.SS."000000"') and I thought the time part would retrieve as military time but they are coming up as am\pm (i.e. 08/06/2008 02:52:43 PM).
I need to have the time be in military time (08/06/2008 14:52:43).
Any help would be appreciated.
Thanks
I need to have the time be in military time (08/06/2008 14:52:43).
Any help would be appreciated.
Thanks