select cast(getdate() as varchar) select convert(varchar,getdate(),101)-

How can u convert the Date to String?

Question Posted / rajesh ranjan

6 Answers
16599 Views
Microsoft, TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

909

What is check constraint in sql server?

957

What is filestream?

945

How to receive returning result from a query?

1039

How to enter date and time literals in ms sql server?

955

What do you mean by a Composite primary key?

1031

How do I find the sql server instance name?

922

What are date and time data types in ms sql server?

1021

Explain cdc and sql injection?

913

How to end a stored procedure properly in ms sql server?

1018

How to rebuild master databse?

1032

Explain about local stored procedure?

903

Define Wed Edition in SQL Azure?

100

What is the order in which the sql query is executed?

882

What is the bookmark lookup and rid lookup?

944