Integer storage

[Deane Venske]

On Tue, 10 Feb 2004 00:54:34 +0200, Ruslan Zasukhin 
<sunshine at public.kherson.ua> wrote:

> on 2/10/04 12:47 AM, Deane Venske at deane.venske at eduss.com wrote:
>
>> Hi Guys,
>>
>> I'm pretty sure there is not, but I was wondering if there is a format 
>> of
>> integers that will allow 14 characters (20040215051530), I'm not even 
>> sure
>> if it would be more efficient than a 14character string anyway. It's
>> basically a time stamp that I format in my program.
>
> Hi Deane,
>
> If you ask about storing of IP, then taking into account that max IP is
>
>     255.255.255.255
>
> This can be stored into ULONG.
>
>
>
> ----------
> 20 040 215 051 530 -- such number can be stored in ULLONG
>
> But  V4MD do not support it, thanks to Lingo
>
> You can try to use it only via strings.
>
>
>
I'm wanting to store a timestamp YYYYMMDDHHMMSS
I've come to not trust any date functionality in any program. I want to 
handle dates myself when it comes to storage. I've had countless problems 
with every DB I've used (MySQL, Access) and prefer a method I know works. 
But ATM I use a Varchar(14) and it's working great. Thought I'd see if I 
could be a little more effecient.

-- 
Deane Venske - Senior Programmer
www.eduss.com.au   deane.venske at eduss.com
+61 7 55974600  +61 405148718
Suite 29,  207 Currumburra Rd
Ashmore, Queensland, 4214
Australia