From: Date: December 21 2004 2:45pm Subject: time inserting problem List-Archive: http://lists.mysql.com/java/8120 Message-Id: <20041221134535.69799.qmail@web51506.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1508893093-1103636735=:69673" --0-1508893093-1103636735=:69673 Content-Type: text/plain; charset=us-ascii Hi , Is there any way to insert time value as '10:00:00 PM', without converting it as 24 hrs format means 22:00:00. My table has one column type, as time , so i wnat to insert as 10:00:00 PM thanks in advance shiva kumar --------------------------------- Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. --0-1508893093-1103636735=:69673--