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
9563 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

Hi Can any one tell me what are the API's used in requisition import.

1879

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1911

How to define an anonymous procedure with variables?

1060

Explain rename?

922

When system tablespace is created?

967

definition of cluster and non-clustered index?

2959

How to retrieve data from an cursor to a record?

1012

Explain oracle instance.

1105

How to generate query output in html format?

1031

Explain what are clusters?

1041

Explain the use of rows option in imp command.

1041

What is Trigger in Oracle?

1074

Which environment variables are absolutely critical in order to run the OUI?

2069

What happens if variable names collide with table/column names?

1101

Why should I use oracle database?

942