Current Timestamp.



IBM's flagship relational database management system

Current Timestamp.

Postby Vineet » Wed Mar 19, 2014 6:33 pm

Hi All,
I have a query Related to CURRENT TIMESTAMP (DB2). I have declare a cursor where I am using Date Extracted from CURRENT TIMESTAMP like "DATE(COL. NAME) = CURRENT TIMESTAMP". My Query is
If I am running my Job in The Night say Around 11:30 PM & date is 19/MARCH/2014 & statement OPEN CURSOR starts executing by 11:30 PM & Date Roll Over Take place i.e. Time is Now 00:15 & Date is 20/MARCH/2014, so to Open The Cursor which Date Time Stamp will be use, will it be of 19/MARCH or 20/MARCH Or data will be fetch from Date 19/March & 20/March Both.

Kind Rgd's
Thanks
Vineet
 
Posts: 86
Joined: Tue Jun 19, 2007 11:38 am
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post