RE: Julian Date Conversion

I think you could just use a fragment by expression like (month(datetime_field) in ("1","2","3")) in dbspace1, (month(datetime_field) in ("4","5","6")) in dbspace2, (month(datetime_field) in ("7","8","9")) in dbspace3, (month(datetime_field) in ("10","11","12")) in dbspace4; to save the effort. Just a thought. James May Database Administrator, Agency for Health Care Administration, Florida voice 904.413.9072 email = mayj@fdhc.state.fl.us }---------- }From: Chris Kaeberlein[SMTP:chrisk@atlanta.com] }Sent: Tuesday, June 10, 1997 5:26 PM }To: informix-list@rmy.emory.edu }Subject: Julian Date Conversion } }Hello, fellow, Informix-ites. } }I'm in need of a function that will convert a datatype of DATETIME YEAR }TO DAY into a Julian date. I've searched all of the Informix literature }and CD documentation that I have at my disposal and haven't been able to }locate anything. The reason I need this function is that I need to }fragment a database table by the DATETIME field, and hopefully fragment }the data evenly across 4 fragments. However, I need to convert the }DATETIME field to a Julian value first in order to use the DATETIME }field in the fragmentation expression. Any help in this matter would be }much appreciated. } }TIA, }Chris } }-- }Chris Kaeberlein }Greenbrier and Russel, Inc. }ckaeberlein@gr.com }