SEO

#1 (**permalink**) 02-29-2008, 07:49 AM

Does anybody can help me to convert datetime value let's '1936-04-13
07:00:00.000' to DATE as '04/13/1936'. I need this value in the Excell as
a DATE format.

Thanks in advance

#2 (**permalink**) 02-29-2008, 07:49 AM

The formatting should be done at the the Excel level, but you can
easily trim the time from a datetime by using the following syntax:

CONVERT(smalldatetime, CONVERT(varchar(10), '1936-04-13 07:00:00.000'))

You basically convert it to a string, trimming off the time stamp, and
then convert it back to a smalldatetime (which save a little on
memory).

Stu

#3 (**permalink**) 02-29-2008, 07:51 AM

SELECT CONVERT(varchar(10), DateColumn, 101)

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

SEO

How to convert datetime to DATE '1936-04-13 07:00:00.000'