Search For
Flagging a Snippet, takes the snippet to Moderator Attention;


0
In order to differentiate AM and PM format in the current time stamp, the below code can be used.

The format Y4-MM-DDBHH:MI:SSBT will set the format here.

SELECT CAST(CAST(CURRENT_TIMESTAMP(0) AS FORMAT 'Y4-MM-DDBHH:MI:SSBT') AS CHAR(22))

Vote! You feel this code is working like charm ? Go a head Login and Press up arrow.
Didn't work ?, press down arrow and let us know the error in comments

Comments