Hi,
What is the best way to insert in a SQL Server field the hours:minutes:seconds?
The best I get it was to define a varchar field and then insert the time as text.
If the datatype of the field was datetime, SQL will always add the date part...
On the othet hand, if I have a dateTime field how can I select only the time of that field (directly using SQL without using VB functions)
Thank you.
Sérgio Oliveira
What is the best way to insert in a SQL Server field the hours:minutes:seconds?
The best I get it was to define a varchar field and then insert the time as text.
If the datatype of the field was datetime, SQL will always add the date part...
On the othet hand, if I have a dateTime field how can I select only the time of that field (directly using SQL without using VB functions)
Thank you.
Sérgio Oliveira