DATE CONVERSIONS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

DATE CONVERSIONS

Author

Topic

jogin malathi
Posting Yak Master

117 Posts

Posted - 2007-07-25 : 01:57:45

HI ALL,

declere @d varchar(10)
declare @t varchar(10)

set @d=convert(varchar,'7/25/2007 10:10:53',101)
set @d=convert(varchar,'7/25/2007 10:10:53',108)

it returns as
@d=7/25/2007
@t=7/25/2007

but @t should be equal to 10:10:53

what's wrong in the conversions

Malathi Rao

Koji Matsumura
Posting Yak Master

141 Posts

Posted - 2007-07-25 : 02:21:08

You are converting varchar to varchar.
Try
set @d = CONVERT(varchar, CONVERT(datetime, '7/25/2007 10:10:53'), 101)
set @t = CONVERT(varchar, CONVERT(datetime, '7/25/2007 10:10:53'), 108)

jogin malathi
Posting Yak Master

117 Posts

Posted - 2007-07-25 : 02:23:19

quote:
Originally posted by Koji Matsumura

You are converting varchar to varchar.
Try
set @d = CONVERT(varchar, CONVERT(datetime, '7/25/2007 10:10:53'), 101)
set @t = CONVERT(varchar, CONVERT(datetime, '7/25/2007 10:10:53'), 108)

thanku got the solution

Malathi Rao

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources