DateTime

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Deni Kusdeni Default port Points: 1457 More actions · Answer 1

Try this

SELECT

getdate() as CurrentDateTime,

substring(convert(varchar(100),getdate(),120),9,2)+'/'+

substring(convert(varchar(100),getdate(),120),6,2)+'/'+

left(convert(varchar(100),getdate(),120),4) as CurrentDate,

substring(convert(varchar(100),getdate(),120),12,2)+':'+

substring(convert(varchar(100),getdate(),120),15,2)+':'+

right(convert(varchar(100),getdate(),120),2) as CurrentTime

Ananda Kumar SSCommitted Points: 1865 More actions · Answer 2

select convert(varchar(11),'27/09/2005 12:42:32 ',103)

Select convert(varchar(10),convert(datetime,'27/09/2005 12:42:32 ',103),108)

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 3

btw this way

select convert(varchar(11),'27/09/2005 12:42:32 ',103)

is still error when

27/09/2005 12:42:32

i change into

2/09/2005 12:42:32

anyanother can help me????????

thanxs you very much for Deni Kusdeni and Ananda Kumar

Otto Schreibke SSC Eights! Points: 943 More actions · Answer 4

Try

Set DateFormat dmy

Declare @dt DateTime

Set @dt = '2/09/2005 12:42:32'

select convert(char(10), @dt, 103), convert(char(8), @dt, 108)

Works for me.

Regards

Otto

Best Regards,

Otto Schreibke

The future is a foreign country, they do things differently there.
(Stolen from Arthur C Clarke)

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 5

thanx you very much for Otto.........

i have try it........ anda success

but do you know the simple procedure that have been created by Microsoft SQL Server Team ????