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

How can u convert the Date to String?

Question Posted / rajesh ranjan

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

How to get the number of affected rows?

1015

How many triggers you can have on a table?

1007

What is the difference between a clustered index and a non-clustered index?

997

What is the use of toad or sqldbx.?

1161

why would you call update statistics? : Sql server database administration

1101

Is t sql the same as sql server?

992

How to check status of stored procedure in sql server?

1000

What is the cpu pressure?

1053

What is a trace frag? Where do we use it?

1111

What is use of @@ spid in sql server?

1223

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

892

What is the use of =,==,=== operators?

1025

What do we need queues in sql service broker?

1080

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8163

If we delete pack Spec what will be the status of pack Body ?

1489