>>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
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
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
>> 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
Isn't it possible to make the collumn an INT.. ??? Or even better, a Date/Time.. ?
What you can try thought (but I don'tthink that this will work) is to multiply the
column(s)
which contains the varchar with 1 when you do the query..
If it should be an varchar.. (can't think of a reason) you
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