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

5 Answers
9777 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between a primary key & a unique key?

1090

How a tablespace is related to data files?

1109

Can sub procedure/function be called recursively?

1003

How will you identify oracle database software release?

1010

What is the data pump import utility?

1035

What is oracle analytical function?

1143

How to drop an index in oracle?

1076

How to store pictures on to the database?

975

How to use fetch statement in a loop?

1019

What is an oracle user account?

990

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1899

How to find out what oracle odbc drivers are installed?

1041

What are the general rules on data consistency?

1009

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2124

How to compare dates in oracle sql?

1103