On Tue, 9 Apr 2002, David BORDAS wrote:
> Sent: Tuesday, April 09, 2002 2:14 PM
> Subject: Re: TIMESTAMP(14) or Bigint ??
>
> TIMESTAMP is 4 Bytes and DATETIME is 8 Bytes. So, 4 Bytes difference
> per 5 Millions records = a 20 MB bigger table ...
David
If storage space is a
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
> David,
> I could be wrong but since bigint isn't a date or time oriented data
> type I imagine this would be completely useless to you unless you are
> storing unix timestamps.
In fact i'
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
> David,
> I could be wrong but since bigint isn't a date or time oriented data
> type I imagine this would be completely useless to you unless you are
> storing unix timestamps.
In fact i'
avid BORDAS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 10:04 AM
Subject: TIMESTAMP(14) or Bigint ??
> Hi,
>
> i'd like to alter a table which have a date and time field so 3 Bytes for
> date and 3 Bytes for time.
> I'd t
Hi,
i'd like to alter a table which have a date and time field so 3 Bytes for
date and 3 Bytes for time.
I'd table to add a new field to store date like this : MMDDHHMMSS.
In fact, I can't use indexes on sql query like select with order by with 2
fields date + time and with
one unique field