Query for format a date time value

Question

Viewing 10 posts - 1 through 9 (of 9 total)

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

arun.sas SSChampion Points: 11831 More actions · Answer 1

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

arun.sas SSChampion Points: 11831 More actions · Answer 2

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

arun.sas SSChampion Points: 11831 More actions · Answer 3

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

arun.sas SSChampion Points: 11831 More actions · Answer 4

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

arun.sas SSChampion Points: 11831 More actions · Answer 5

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

arun.sas SSChampion Points: 11831 More actions · Answer 6

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

arun.sas SSChampion Points: 11831 More actions · Answer 7

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

arun.sas SSChampion Points: 11831 More actions · Answer 8

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)

arun.sas SSChampion Points: 11831 More actions · Answer 9

Hi,

Try this

select getdate()

select convert(varchar(20),getdate() ,113)