OraFAQ Forum: SQL & PL/SQL » Truncate date string to mm/yyyy

Home » SQL & PL/SQL » SQL & PL/SQL » Truncate date string to mm/yyyy

Thu, 08 February 2007 10:49

sharaiqa
Messages: 7
Registered: February 2007

Junior Member

Hello Forum,

Does anyone know how to truncate a date string so that it will only return mm/yyyy using to_char

[Updated on: Thu, 08 February 2007 10:51]

Thu, 08 February 2007 11:00

ebrian
Messages: 2794
Registered: April 2006

Senior Member

to_char(<date_column>, 'MM/YYYY')

Of course, this is assuming the <date_column> is truly a DATE field.

[Updated on: Thu, 08 February 2007 11:01]

Previous Topic:	Preference: unique index or unique constraint?
Next Topic:	Date time in my sql

Goto Forum:

]

Current Time: Wed Apr 24 21:31:13 CDT 2024