|
In Oracle: SQL> ALTER SESSION SET nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’; Session altered. SQL> SELECT TRUNC(sysdate) FROM DUAL; TRUNC(SYSDATE) ——————– 2009-MAY-10… READ MORE
|
There are few ways to calculate end of day i.e when the time is 23:59:59. In the example below it… READ MORE
“Control what I can control”
~ Alex Lima