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
- 14036 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
What are the restrictions that views have to follow? : SQL Server Architecture
What is a collation?
What is openrowset sql server?
How do I delete a sql server database?
what is dbcc? : Sql server database administration
How optimize sql query with multiple joins in sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What does it mean to be in union?
What are binary string data types in ms sql server?
what is the sql equivaent of the dataset relation object ?
what are different types of backups available in sql server? : Sql server database administration
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How to select an exiting database using mssql_select_db()?
How to make a column nullable?
Write a sql query to get zero records from a table having n number of records?
