Extracting date fields from a DATE data type

Hi, I need to extract the date fields (year, month, day, hour, minute, second) from a date field. I could probably convert the date to char, do a substring operation to get the needed field, and convert it back to number. But this is very awkward. Is there any function that does this kind of thing directly?

thanks.
reddy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 10 1998 - 18:01:06 CDT