How can u convert the Date to String?
Answer Posted / rajesh ranjan
select cast(getdate() as varchar)
select convert(varchar,getdate(),101)-mm/dd/yyyy
select convert(varchar,getdate(),102)-yy.mm.dd
select convert(varchar,getdate(),106)-ddmmyy
select convert(varchar,getdate(),108)-hh:mm:ss
etc.
Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What to check if a User database is locked?
What is the full form of dql?
Where are stored procedures in sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How many types of database relationship in sql server?
Why normalization is used?
What is an indexed view?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How to list all stored procedures in the current database using ms sql server?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is trigger in salesforce?
Can you explain what is the use of custom fields in report?
Can you index views?
What is the purpose of sql profiler in sql server?
What is collation sensitivity? Explain different types.