AM PM in Current_timestamp

UDA

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
2 REPLIES
Teradata Employee

Re: AM PM in Current_timestamp

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))
Enthusiast

Re: AM PM in Current_timestamp

Thank you very much  :)

NS