DB2 - Fetch the current date and time in the following format
24/APRIL/12 17:30:22:2000

 Posted by Bandi on 11/30/2013 | Category: Others Interview questions | Views: 1584 | Points: 40
Answer:

SELECT VARCHAR_FORMAT(CURRENT TIMESTAMP, 'DD/MONTH/YY HH24: MI:SS: NNNNNN’) FROM SYSIBM.DUAL


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response