Converting a DATE with time stamp to a DATE without timestamp

[Anisht79menon]

I want to convert a DATE with time stamp(stored in a column of a table of data type as DATE ) to a DATE without time stamp.

I have a constraint also, I can't use TO_CHAR function.

Example.

Date needs to be converted , START_DATE = '31/12/9999 11:42:27'

Covert this date to '31/12/9999'.

If we use TRUNC some times its correct.If NLS_DATE_FORMAT is different then this would be a problem.

Can anyone would be able to sort out this Issue?

Please give me the solution if possible.

[Dilip1983]

Try to_date(start_d ate,'DD/12/YYYY').

Let me know if it helps or not.

[amitpatel66]

Why you cant use TO_CHAR function?