Interested to Buy Any Domain ? << Click Here >> for more details...
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 ...."??
- 8 Answers
- 14452 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
How many types of attribute relationships are there? : sql server analysis services, ssas
Can you force a query to use a specific index?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Can a table be created inside a trigger?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Can sql server 2016 run on windows 7?
What is sleeping status in sql server?
Explain the difference between clustered and non-clustered index?
How to create new table with "create table" statements?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is RAID? What are the different types of RAID configurations?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Which rendering formats are affected by the pagesize properties?
How secure is sql server database?
how to invoke a trigger on demand? : Sql server database administration
