Hello, i want to convert a mysql to derby database. So, I want to find an equvivalent for DATE_FORMAT() function in mysql. I have a timestamp field in my table and I want to know how we can fetch only the hour part from the timestamp in derby. similary, second part, day part etc. I am using PHP as my front end. I saw this link http://www.seemoredata.com/en/showthread.php?42-using-Derby-database-Timestamps-intelligently but the functions there dont work in derby. Please advice! i really need some input on this..
-- View this message in context: http://old.nabble.com/Fetch-the-hour-part-from-the-timestamp-value-tp28726194p28726194.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.
