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
- 14319 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 to add a new column to an existing table with "alter table ... Add" in ms sql server?
What do you mean by acid?
Define outer join?
What is difference between table aliases and column aliases? Do they affect performance?
What are different backups available in sql server?
Is foreign key a primary key?
What is replication with database mirroring? : sql server database administration
Tell me what are the advantages of using stored procedures?
What is catalog views?
How can we get count of the number of records in a table?
How many types of objects are there?
What is function of CUBE ?
what is the difference between count(*) and count(1) ?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What is an indexing strategy?
