SHYAM IIB
Tuesday, June 27, 2017
ESQL Time Stamp Changes :
Code :
DECLARE target TIMESTAMP;
SET now = CAST(CURRENT_TIMESTAMP AS CHARACTER FORMAT 'yyyy/MM/dd-h:mm:ss a');
Output :
Related IBM Links for Time Stamp :
https://www.ibm.com/support/knowledgecenter/en/SSMKHH_9.0.0/com.ibm.etools.mft.doc/ak05616_.htm
CAST Function:
https://www.ibm.com/support/knowledgecenter/en/SSMKHH_9.0.0/com.ibm.etools.mft.doc/ak05610_.htm
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment