Trunc

This is a discussion on "Trunc" within the Databases section. This forum, and the thread "Trunc are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old May 11th, 2007, 22:28
New Member
Join Date: May 2007
Location: boston
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Trunc

can someone explain to me what is going on here

Code: Select all
UPDATE primary_mst set box_name_change = TRUNC(box_name_change);
Reply With Quote

  #2 (permalink)  
Old May 12th, 2007, 04:51
Reputable Member
Join Date: Jul 2005
Location: Melksham, Wilts, UK
Posts: 293
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Trunc

Reduce the box_name_change component of each row in the primary_mst to (in effect) an integer, even though the field type is something more flexible.

[Looks like a MySQL question - isn't this the PHP board? ]
Reply With Quote
  #3 (permalink)  
Old May 12th, 2007, 04:56
New Member
Join Date: May 2007
Location: boston
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Trunc

ya, i am sorry. my mistake, anyways thanks for your help amigos :-)
Reply With Quote
  #4 (permalink)  
Old May 12th, 2007, 15:28
Reputable Member
Join Date: May 2006
Location: Northampton, UK
Posts: 399
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Trunc

Moved to MySQL forum
Reply With Quote
Reply

Tags
mysql, noob, php, sql, trunc

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 07:59.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43