How to code a date ?

[Ruslan Zasukhin]

On 10/22/04 6:01 AM, "Thierry Nauze" <ohmitou at wanadoo.fr> wrote:

Hi Thierry, 

> How to to code a date when I kown only the year and possibily the month
> 
> July 25, 2004   -> 2004/07/25
> 
> July, 2004 ->   ????  :  2004/07/..  or  2004/07/00  or other string ?
> 
> 2004 ->  2004/../..  or  2004/00/00   or other string ?
> 
> The three dates are stored in the same field.

Code for storing on disk or for searching ?

For storing you can do

    INSERT ... ( '2004/00/00' )


For search you can use LIKE or REGEX

    WHERE fld LIKE '2004/??/??'


    WHERE fld REGEX '2004/../..'



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------