OT (was: Is converting string to integer possible?)

Jerry writes: > How did you know I have an Amiga??? I know everything about everybody. I'm god. :-) Or actually, I just looked at the mail headers. But hey, you can still call me god if you want to. ;-D //C - more diabolic than divine -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353

Re: Re: Is converting string to integer possible?

>>That makes me wonder... what happens if longlong is not supported or >>is less than 64 bits wide? I have no experience of gcc on AmigaOS, >>but I would expect it to support longlong (heck, even >>SAS/C does as far as I can remember (don't quote me on that - >>although I own a copy of it I have

Re: Is converting string to integer possible?

Sergei Golubchik writes: > > Is 14 number digit to much to use > > 14 digit number is ok - MySQL uses longlong internally > and can handle up to 9223372036854775807. Of course, your platform > should support it, but it, probably, does. That makes me wonder... what happens if longlong is not s

Re: Is converting string to integer possible?

Hi! On Nov 27, Jerry wrote: > >> Hi > >> > >> I have 2 text columns VARCHAR 50 and I put a date in them in format > >> > >> mmddhhmmss > > >> Is there a way to force string to be read as interger (same as CINT in > >> VBScript, but I need to to this in mySQL). > > >Yes, string_expression+0

Re: Is converting string to integer possible?

>> Hi >> >> I have 2 text columns VARCHAR 50 and I put a date in them in format >> >> mmddhhmmss >MySQL does have a DATETIME type, which would probably be better >suited to your needs. Hm, yes, but I have a forum set to this variable type (Snitz forum also has with VARCHAR not DATETIME). Mor

Re: Is converting string to integer possible?

ink of a reason) you can maybe keep a second column with the INT version..? Bye David - Original Message - From: "Jerry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 04:00 Subject: Is converting string to integer possible? > Hi > &

Re: Is converting string to integer possible?

Jerry writes: > Hi > > I have 2 text columns VARCHAR 50 and I put a date in them in format > > mmddhhmmss MySQL does have a DATETIME type, which would probably be better suited to your needs. > Is there a way to force string to be read as interger (same as CINT in > VBScript, but I need

Is converting string to integer possible?

Hi I have 2 text columns VARCHAR 50 and I put a date in them in format mmddhhmmss All working well, but I need to compare this field with the curent date and it doesn't work, as both fields are string. Is there a way to force string to be read as interger (same as CINT in VBScript, but I n