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



Posted by Syam S Kanduri at 10:40 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Syam S Kanduri
View my complete profile

Blog Archive

  • ►  2019 (1)
    • ►  December (1)
  • ▼  2017 (11)
    • ►  July (6)
    • ▼  June (5)
      • Set the persistence in message level :          ...
      • IV Questions : 1. Folders create when we deploy ...
      • Command to check entire execution group informat...
      • Deployment Issues :     When we do deployment di...
      • ESQL Time Stamp Changes :  Code :  DECLARE ...
Simple theme. Powered by Blogger.