Select Convert(varchar,getdate(),114) As DateTime It is Only Run In Sql

how to truncate date and get only time part 9:20:00

Question Posted / kumar.t

Answer Posted / kumar.t

Select Convert(varchar,getdate(),114) As DateTime

It is Only Run In Sql Server2000

By

Kumar .T

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Design database draw er diagram for a certain scenario ?

4656

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

What is oracle latest version?

1174

How to put more than 1000 values into an oracle in clause?

1115

How to select all columns of all rows from a table in oracle?

1132

How to write a left outer join with the where clause in oracle?

1155

How to start an oracle instance?

1103

How to use values from other tables in update statements using oracle?

1158