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 ...."??
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / deepa
select getdate()
select Dateadd(dd,2,getdate())
select convert(varchar(12),Dateadd(dd,2,getdate()),106)
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / shailesh s. deshmukh
select convert(varchar(20),getdate(),106)
Is This Answer Correct ? | 4 Yes | 1 No |
Try this this will works fine.
select convert(varchar,dateadd(day,2,getdate()),106)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
How can we improve performance by using SQL Server profiler?
What is the difference between getdate and sysdatetime?
Can you explain the types of Joins that we can have with Sql Server?
What are “phantom rows”?
Explain the microsoft sql server delete command?
How many cores do I need for sql server 2016?
Explain about integration services of Microsoft SQL server?
Is sql server implemented as a service or an application? : Sql server database administration
What are the different types of cursor?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What does it mean to invest in the index?