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

How can u convert the Date to String?

Question Posted / rajesh ranjan

6 Answers
17059 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

Write down the syntax and an example for create, rename and delete index?

1028

What is unique key constraint?

1118

What is data source view or dsv? : sql server analysis services, ssas

1065

Explain where clause?

1034

What is the difference between a primary key and a unique key? Are they the same?

1126

What is dbcc updateusage?

1258

What is an index in sql?

1070

How to create a scrollable cursor with the scroll option?

1050

Should you normalize audio?

1008

How to create a view with data from multiple tables?

1065

What are different types of table joins?

1055

Why use triggers?

1069

What is replication with database mirroring? : sql server database administration

1152

What are the dmvs?

1074

Please differentiate between a local and a global temporary table?

1059