Retrieving Day, month and Year separately from the date

[kalai sundari]

can any one of you how to retrieve only the day or month or year value alone from the database when the date is strored in dd/mm/yy format??

[dorinbogdan]

Use day(), month() or year() SQL system functions, like:

select day('12/20/2006'), month('12/20/2006'), year('12/20/2006')

[Taftheman]

can any one of you how to retrieve only the day or month or year value alone from the database when the date is strored in dd/mm/yy format??

Try to google the "DatePart" function to give you more info on this