Dear friend try this one select convert(varchar(11), getdate(),106)+(SEL

system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??

Question Posted / shailesh s. deshmukh

8 Answers
14189 Views
I also Faced
E-Mail Answers

Answer Posted / shailesh s. deshmukh

Dear friend try this one

select convert(varchar(11), getdate(),106)+(SELECT right
(GETDATE(),8))
as Date

or

select convert(varchar(11), getdate(),106)+(SELECT STUFF
(getdate(), 1, 11, ''))
as Date

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Where views are stored in sql server?

939

What is BCNF? How is it better than 2NF & 3NF?

984

What are acid properties of transaction?

914

How to recompile stored procedure at run time?

1031

Do you know what are the ways available in sql server to execute sql statements?

990

How important do you consider cursors or while loops for a transactional database?

932

how to invoke a trigger on demand? : Sql server database administration

1029

What is mscorsvw.exe - process - microsoft .net framework ngen?

921

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1034

How to list all login names on the ms sql server?

1103

What are the types of subquery?

1002

what is dbcc? : Sql server database administration

990

what are different types of backups available in sql server? : Sql server database administration

908

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

909

What is right outer join in sql server joins?

1136