[SOLVED] date format

[suyesh.amatya]

2008-08-06 10:43:50

this is the format that date is stored in mysql table.

Now after fetching from the database,how can i only extract only the year or month portion from this.

[MasterACE14]

you could use substr();

[suyesh.amatya]

SELECT *,extract(year from date_of_post)as year from table

 

The format is EXTRACT(date_type FROM date_column) where date_type is the component to retrieve and date_column is the name of the column from which to extract data

 

This query gives the desired result,without the overhead of string manipulation after fetching from the database.