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

How to insert a new row into a table in oracle?

1217

How will you differentiate between varchar & varchar2?

1086

How to write numeric literals in oracle?

1238

What are set operators?

1144

How to execute a stored procedure in oracle?

1148

What is different types of joins?

1080

What is Data Dictionary Cache in Oracle?

1244

How to retrieve data from an cursor to a record?

1158

How to create a new tablespace in oracle?

1035

defination of bitmap index

2180

How to export several tables together?

1106

How do I connect to oracle database?

1199

Explain how you would restore a database using RMAN to Point in Time?

2188

How to check your oracle database 10g xe installation?

1053

How do we display rows from the table without duplicates?

1019