How to truncate time in date field?

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 00:00:00

In SQL Server:

SELECT CAST(CONVERT(varchar, GetDate(), 101) AS DateTime)
2009-05-10 00:00:00.000

Leave a Reply