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
- 14439 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapan
select convert(varchar(20),getdate()+int,100)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a trigger? Why we need it?
How to test values returned by a subquery with the in operator?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How many servers can we create in a single subscription?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How are the exceptions handled in sql server programming?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
which backup strategy you are following at ur company
Explain few examples of stored procedure over triggers?
What command is used to delete a table from the database in the sql server and how?
What are partitioned views and distributed partitioned views?
What are the different type of replication in sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Can you create a logon trigger in sql server 2005 express edition?
