mm/dd/yyyy hh:mm:ss to mm/dd/yyyy

#1

How I can change a date column in format mm/dd/yyyy hh:mm:ss to mm/dd/yyyy fro
Query Analyzer?

#2

Here is a user defined function that will do it for you

CREATE FUNCTION fn_datenotime
(@cdate datetime )
RETURNS smalldatetime
AS
BEGIN
return
ltrim(str(month(@cdate)))+'/'+ltrim(str(day(@cdate)))+'/'+ltrim(str(year(@cd
ate)))
END

The call would be dbo.fn_datenotime(date)

Otherwise you can do a lengthy one with functions

ltrim(str(DATEPART(mm, date)))+'/'+ltrim(str(DATEPART(dd,
date)))+'/'+ltrim(str(DATEPART(yyyy, date)))

"Arthur" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

How I can change a date column in format mm/dd/yyyy hh:mm:ss to
mm/dd/yyyy from
Query Analyzer?

#3

How about

select CONVERT(VARCHAR(10),YourDateTime,101) FROM YourTable

--

Andrew J. Kelly
SQL Server MVP

"Ed Willis" <ed_willis (AT) acsi (DOT) orgnospam> wrote

Quote:

Here is a user defined function that will do it for you

CREATE FUNCTION fn_datenotime
(@cdate datetime )
RETURNS smalldatetime
AS
BEGIN
return

ltrim(str(month(@cdate)))+'/'+ltrim(str(day(@cdate)))+'/'+ltrim(str(year(@cd
ate)))
END

The call would be dbo.fn_datenotime(date)

Otherwise you can do a lengthy one with functions

ltrim(str(DATEPART(mm, date)))+'/'+ltrim(str(DATEPART(dd,
date)))+'/'+ltrim(str(DATEPART(yyyy, date)))

"Arthur" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:0A3A1CDF-377C-4722-A2B0-E447288DE52D (AT) microsoft (DOT) com...
How I can change a date column in format mm/dd/yyyy hh:mm:ss to
mm/dd/yyyy from
Query Analyzer?

#4

Many thanks
Both of your solutions were successfull
Thanks for you help and thanks to Microsoft SQL Server
Discussion Group.

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

mm/dd/yyyy hh:mm:ss to mm/dd/yyyy

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

mm/dd/yyyy hh:mm:ss to mm/dd/yyyy - 02-19-2004 , 01:46 PM

Re: mm/dd/yyyy hh:mm:ss to mm/dd/yyyy - 02-19-2004 , 03:16 PM

Re: mm/dd/yyyy hh:mm:ss to mm/dd/yyyy - 02-19-2004 , 03:22 PM

Re: mm/dd/yyyy hh:mm:ss to mm/dd/yyyy - 02-20-2004 , 07:56 AM