[Gambas-devel] Date Value

[nigel at ...2...]

Charlie,

You are correct.  Remember that there is no such type as Date in true sqlite and that  the gambas driver tries to approximate it.  This problem generally only appears if you use the Exec to insert a value.  If you used the independent gambas methods table!fieldname = value then the conversion would happen automatically.

Nigel

> Message date : Mar 25 2005, 08:26 PM
> From : "Charlie Reinl" <na2492 at ...16...>
> To : gambas-devel at lists.sourceforge.net
> Copy to : 
> Subject : Re: [Gambas-devel] Date Value
> 
> >Benoit, 
> > 
> >I'm looking at adding more date related functions to gambas, for example 
> a julian function to return julian dates from gregorian.  Looking at the 
> code in gbx_date.c I am uncertain as to whether value->_date.date (ndays) 
> is the julian value. (It is a slightly different value from the values 
> calculated using the formula that I am use to). e.g. The gambas date value 
> 
> for 01/01/2005 is 2485476 whilst the Julian is 2453372. 
> > 
> >Is the value intended to be Julian or is the value only specific to 
> gambas? 
> > 
> >Kind regards 
> > 
> >Nigel 
> > 
> Salut Nigel, 
>  
> while you talking Dates. 
> I remaked that, if you insert into a SQlite table values like 
> '1872-7-4','1933-1-5', SQLite hase problem with (mySQl and postgres 
> haven't) 
> to make it run for all 3 you have to write '1872-07-04','1933-01-05' 
> So I think it's perhaps a SQLite-driver problem. 
> You can see that in the attached project.The insert into you find in 
> FSampl. 
>  
> Amicalment 
> Charlie 
> * Gesendet mit / Sent by: FEN-Webmail * http://www.fen-net.de *
> >
> [ DBTableView-0.0.5.tar.bz2 (153.5 Kb) ]

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm