All Forums UDA
meera_intel 1 post Joined 10/08
19 Oct 2008
AM PM in Current_timestamp

select current_timestamp(0) returns, 2008-10-19 09:04:18+00:00 for 9 PM. There is no information on AM/PM. How to convert this to AM/PM format or 24-hour format?Thanks,Meera

Fred 1096 posts Joined 08/04
19 Oct 2008

It's 24-hour time by default. You can use FORMAT to display AM/PM indicator, e.g.cast(cast(current_timestamp(0) as format 'y4-mm-ddbhh:mi:ssbt') as char(22))

snaren777 9 posts Joined 08/11
26 Jul 2012

Thank you very much  :)



You must sign in to leave a comment.