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: 3489 | Points: 40

Answer:

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

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Display the employee details who are working ...

Next > : DB2 - Find the NAMEs that have an even number of l ...

More Interview Questions by Bandi

Latest Interview Questions