Date Format Question

[mulliganradio]

I have a view that I would like to add a field to (for the purpose of linking to another view). I need take the original date/time field "5/24/2000 6:30:00 AM" and convert it to "5/24/2000 0:00:00 AM" so I can link it to a field in another view that has date only (5/24/2000 0:00:00 AM)

I was able to do this in SQL by typing the following but need to know how to do this in Oracle:

SELECT
SH.STARTDTM AS SHIFTSTARTDATE,
CONVERT(CHAR(10),SH.STARTDTM,101)AS SHIFTSTARTDATE_CUST

 

[BJCooperIT]

Try:

select trunc(SH.STARTDTM)

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Systems Project Analyst/Custom Forms & PL/SQL - Oracle/Windows