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

Does oracle partitioning improve performance?

967

What is the best way to do multi-row insert in oracle?

1048

What is the usage of save points in oracle database?

947

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1081

how to do daily transactions with out sql* loader control file regesterd in apps?

1664

Explain the use of tables option in exp command.

1097

How to load data through external tables?

1118

What is the difference between I and G in Oracle?

1076

How to insert a record into a table?

1050

What suggestions do you have to reduce the network traffic?

936

What is format trigger?

2056

How to update values on multiple rows in oracle?

1015

How to recover a dropped table in oracle?

1021

What is Java Pool in Oracle?

1143

What are the components of logical database structure in oracle database?

1061