year month date format?

nirmalsingh

New Member

Join Date: Sep 2006

Posts: 218
#1

year month date format?

Jun 30 '07, 08:52 PM

hai all,
i would like to have a sql server date function to fetch my datetime field as yyyy-mm-dd. ur assistance is appreciated. thanx in advance.
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Jul 2 '07, 06:53 PM

Originally posted by nirmalsingh

hai all,
i would like to have a sql server date function to fetch my datetime field as yyyy-mm-dd. ur assistance is appreciated. thanx in advance.

check the datepart() function
Comment

Comment