Joined: 22 Sep 2013 Posts: 81 Location: pune india
Multiple times i have come across below question in interview.
How to retive current date,time and timestramp from a table and how to recieve them in host varibales
I give them below answers but they wanted to retieve from the table
SELECT CURRENT_TIME FROM SYSIBM.SYSDUMMY1;
SELECT CURRENT_DATE FROM SYSIBM.SYSDUMMY1;
SELECT CURRENT_TIMESTAMP FROM SYSIBM.SYSDUMMY1;