How can u convert the Date to String?
Answer Posted / samba shiva reddy . m
SELECT
GETDATE() AS UnconvertedDateTime,
CAST(GETDATE() AS nvarchar(30)) AS UsingCast,
CONVERT(nvarchar(30), GETDATE(), 126) AS UsingConvertTo_ISO8601 ;
GO
this will work for u try it out.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What happens if null values are involved in datetime operations?
Disadvantages of the indexes?
Where can you add custom error messages to sql server?
What happens if strings are casted into wrong code pages in ms sql server?
What are different types of database indexes?
What is change data capture (cdc) feature?
How to delete a database in ms sql server?
How to drop an existing stored procedure in ms sql server?
How do you rebuild an identity column?
How do clustered indexes store data?
How will you know when statistics on a table are obsolete?
How do you start single user mode in clustered installations?
When a primary key constraint is included in a table, what other constraints does this imply?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What is the difference between a "where" clause and a "having" clause?