problme with sql queries

[Mintoo kumar]

Hi all,

I have one query

___________________________________________________________________________
SELECT TO_CHAR(TO_DATE('05/14/2008 11:20:25PM', 'MM/DD/YYYY HH12MISS'), 'YYYY/MM') FROM myDB;

___________________________________________________________________________

i have time stamp in database in format like '05/14/2008 11:20:25PM'.
i want it to convert into format like YYYY/MM.However i have tried the aboce query but could not get the desired result.

I am using PLSQL devloper as a editor and my databae is in oracle.

Does anybuddy have anyidea. how to do.

[Herman Schelti]

hi,

just add a few ":", like

SELECT TO_CHAR(TO_DATE('05/14/2008 11:20:25PM', 'MM/DD/YYYY HH:MI:SSPM'), 'YYYY/MM') FROM DEPT

Herman