Hi Vaan,
Thanks... I just found references to using a specific date function which
I'm going to try out.
convert string to datetime object:
strftime('%Y-%m-%d %H:%M:%S','timeStringShouldGoHere','localtime')
Cheers,
!k
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Vaan S Lanko
Sent: Monday, April 07, 2008 10:39 AM
To: [email protected]
Subject: Re: [flexcoders] AIR SQL - Datatype issues
Hey Kevin,
Heres an example of some sql text on a SQLStatement that I use in an AIR
app I'm building. I use a dateformatter for the actual date output i.e
'2008-04-06' and if I need the time component, I just build up and
replace the end of the text with my vars, its not pretty but it works
fine. The thing to watch out for is that AS regards 12am as 24 rather
than 00. Hope that helps..
Cheers
Vaan
select * from Foo where bar_id = "2" and datetime(date) =
datetime('2008-04-06 00:00:00');
Kevin Aebig wrote:
>
> Hey all,
>
> I've looked at the documentation about 400 times now and can't seem to
> find myself an example of using a column of datatype Date within AIR
> SQL. I know that it's been customized to use Actionscript / JavaScript
> Date objects, but I can't get it to work properly for the life of me.
> Any examples or pointers?
>
> Cheers,
>
> !k
>
>
------------------------------------
--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives:
http://www.mail-archive.com/flexcoders%40yahoogroups.comYahoo! Groups Links
