How to extract time from datetime stored in database?

0 ⤊

Thanx for the answer. But the problem remains how to extract
time from datetime stored in SQL server database

2007-01-01 15:41:39 · 2 answers · asked by vishakha 1 in Computers & Internet ➔ Programming & Design

The langauge is VB6.I'm using Format function to extract time from date but it is not getting saved in database. The error is
SqlDateOverflow.

2007-01-01 19:50:45 · update #1

DATE(field_name)
It might help.

2007-01-01 17:40:27 · answer #1 · answered by Vaibhav 4 · 0⤊ 0⤋

What language?!

2007-01-01 17:22:14 · answer #2 · answered by Kasey C 7 · 0⤊ 0⤋