zulkifly_said 0 Report post Posted June 28, 2004 nak tanya kawan2, boleh tak untuk formatkan time, date dalam query siapsiap dalam mySql.iaitu kalau dalam Oracle kita pakai to_string('dd/mm/yyyy.....).tq Quote Share this post Link to post Share on other sites
DevGuy 0 Report post Posted June 28, 2004 aku rasa kat mysql dah ada.normally MySQL using YYYY-MM-DD utk date format.tapi Mysql support string utk formatcontoh '98-12-31 11:30:45', '98.12.31 11+30+45', '98/12/31 11*30*45', '98@12@31 11^30^45'guna datetime,date atau timestamp functiondownload manual MySQL .kat situ ada. Quote Share this post Link to post Share on other sites