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.