Posted by Paul Lautman on 01/21/07 12:49

Dale wrote:
> A table has a field containing the date and time. Example 2006-2-20
> 08:11:44.123...field name is DateInitiated. I can extract the month,
> day and year by using Day(DateInitiated), Month(DateInitiated),
> Year(DateInitiated). How would the time be extracted for hours,
> minutes and seconds?
> Thanks!

Would you believe HOUR() MINUTE() SECOND, or is that too obvious!

[Back to original message]