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))
You must sign in to leave a comment.
|
Enterprise | Welcome to the Teradata Forums.
Read the
guidelines on posting.
Email notifications and RSS feeds are available, and also a chronological list of all forum activity. |
|
|
|
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