Format Date for Output to Text File

#1

What's the best method for formatting a date from a standard SQL Server
datetime format to ddmmmyyyy (e.g., 12DEC2005) in an export query?

Thanks,
Rob

#2

See function convert in BOL.

Example:

select replace(convert(varchar(11), getdate(), 113), ' ', '')
go

AMB

"Robert Hamilton" wrote:

Quote:

What's the best method for formatting a date from a standard SQL Server
datetime format to ddmmmyyyy (e.g., 12DEC2005) in an export query?

Thanks,
Rob

#3

Thanks!

"Robert Hamilton" wrote:

Quote:

What's the best method for formatting a date from a standard SQL Server
datetime format to ddmmmyyyy (e.g., 12DEC2005) in an export query?

Thanks,
Rob

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

Format Date for Output to Text File

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Format Date for Output to Text File - 05-02-2005 , 12:54 PM

RE: Format Date for Output to Text File - 05-02-2005 , 02:11 PM

RE: Format Date for Output to Text File - 05-02-2005 , 03:13 PM