sql server programming: Date -- sql server programming

RE: Date

Nigel Rivett
6/14/2004 7:02:01 PM

sql server programming:

Store in a datetime and return using

select left(replace(convert(varchar(8),dte,10),'-',''),6)

[quoted text, click to view]

Date	HartmanA 6/14/2004 8:15:31 PM

Whice Date function would I use If I wanted to take a dateTime field in my
table and produce this output.

06/14/04 to 061404 ---> and I need to kept both postions of MMDD

Thanks.

Re: Date

HartmanA
6/14/2004 9:10:03 PM

Thanks again.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.