how to truncate date and get only time part 9:20:00
- 5 Answers
- 8543 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
What is oracle sid?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to write date and time literals in oracle?
How to write a query with a left outer join in oracle?
Who developed oracle & when?
what is the difference between substr and instr function in oracle?
how to handle exceptions in post production
What is rich query?
what are the advantages of running a database in archive log mode?
What is proxy method?
What does sharding mean?
How do I connect to oracle?
What is oracle in java?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are group functions in oracle?
