DBTIME and time date types

hello, I am being passed in a character string which contains a date/time in the following format: YYYY-MM-DD HH:MM:SS ex: 1998-05-18 09:05:00 I need to convert it such that it looks like the below: Mon May 18 09:05:00 EDT 1998 <-- output like that of unix time() I would like to know if there is an easy way to do the above. I am able to obtain the above format except for the day of the week and the time zone by making calls to dtcvasc() to convert to a datetime, and then using dttofmtasc() with formatting. Is there a general utility either in Informix or in C that can allow me to print the day of the week?? Thanks, apatnaik@aircom.com -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum