esostigma Posted May 22, 2007 Share Posted May 22, 2007 hi what happens here: UPDATE primary_mst set box_name_change = TRUNC(box_name_change); Link to comment https://forums.phpfreaks.com/topic/52568-trunc/ Share on other sites More sharing options...
Barand Posted May 22, 2007 Share Posted May 22, 2007 Pass. What does is say about TRUNC() in the manual for whatever dbms you are using? Link to comment https://forums.phpfreaks.com/topic/52568-trunc/#findComment-259396 Share on other sites More sharing options...
esostigma Posted May 22, 2007 Author Share Posted May 22, 2007 sql databases using php, perhaps a link to where i could find this information might help. yes i have googled. i'm very new to this, i don't understand a lot of jargon, which is why i came to a forum. ty Link to comment https://forums.phpfreaks.com/topic/52568-trunc/#findComment-259400 Share on other sites More sharing options...
Barand Posted May 22, 2007 Share Posted May 22, 2007 First, what dbms are you using? Link to comment https://forums.phpfreaks.com/topic/52568-trunc/#findComment-259402 Share on other sites More sharing options...
esostigma Posted May 22, 2007 Author Share Posted May 22, 2007 i thought you may have meant : dbms (database management system) i thought that was sql. now i think you may mean something like oracle. if you do, then i don't know, this is a little research assignment to see what resources i can pull off the web to figure something out. i was not given information as to whether it is oracle or something. ty Link to comment https://forums.phpfreaks.com/topic/52568-trunc/#findComment-259405 Share on other sites More sharing options...
trq Posted May 22, 2007 Share Posted May 22, 2007 sql databases using php PHP can connect to many different kinds of databases, mysql is most common, but... as far as I can tell there is no such function (TRUNC) available in mysql. i thought you may have meant : dbms (database management system) i thought that was sql SQL is a language, not a database. It is the language that you use to query databases. Each dbms has its own flavor of sql though. Link to comment https://forums.phpfreaks.com/topic/52568-trunc/#findComment-259408 Share on other sites More sharing options...
Barand Posted May 22, 2007 Share Posted May 22, 2007 Most references when googling "SQL TRUNC" seem to be oracle, so I'd start with Oracle's manual. Link to comment https://forums.phpfreaks.com/topic/52568-trunc/#findComment-259410 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.