date from datetime

#1

Does anybody knows how can i reterive date from datetime
field .i don't want time .Thanx in advance

#2

See cast and convert in BOL

convert(varchar,datecolumn,112)

--
Ray Higdon MCSE, MCDBA, CCNA
---
"saurabh Saxena" <saurabhs (AT) vit (DOT) ac.in> wrote

Quote:

Does anybody knows how can i reterive date from datetime
field .i don't want time .Thanx in advance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

date from datetime

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq

date from datetime - 03-02-2004 , 06:13 PM

Re: date from datetime - 03-02-2004 , 07:23 PM