select to_char('sysdate',dd mon yyyy)from dual convert the

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 / praveen kumar.dandu

8 Answers
14774 Views
I also Faced
E-Mail Answers

Answer Posted / praveen kumar.dandu

select to_char('sysdate',dd mon yyyy)from dual

convert the date format to chars and retrive the the system
date in the format what eve r u like

Is This Answer Correct ?

9 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is NOT NULL Constraint in sql server 2012?

1047

How many instances per computer are there in sql server 2000?

1122

What is database mirroring?

1176

Does group by or order by come first?

1001

Differentiate between a primary key and a unique key.

1120

What is the default port for SQL Server over a firewall?

1145

How do I run a trace in sql server?

1043

what is a self join? Explain it with an example? : Sql server database administration

1002

What happens when converting big values to numeric data types?

1229

What is open database communication (odbc)?

1118

Do you know what is similarity and difference between truncate and delete in sql?

1067

What happens to a statement batch if there is a compilation error?

1012

How do you improve the performance of a SQL Azure Database?

137

What is the maximum size of a dimension? : sql server analysis services, ssas

1090

Can we do dml on views?

1018