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 is exporting and importing utility?
What are the different subsets of sql?
what purpose does the model database serve? : Sql server database administration
What are the indexes in sql server?
What is #temp and @table variable in SQL server?
Explain what is scheduled job and how to create it?
What is ms sql server service broker?
How to create dbo table in sql server?
Explain how dts is used to extract, transform and consolidate data?
Do you know the policy based administration feature of sql server 2008?
What new data source types were added in ssrs 2014?
What is the Difference Between Primary and Foreign Key?
What is the contrast between sql and pl/sql?
Why is sql server log file full?
What is @@error in sql?