european date format for sql database statement

[asdfg]

I am having trouble with an SQL statement in LV7.0. With my machine configured with a Short Date format of Day/Month/Year (Australia)

I ask the database for the timestamp of the most recent record. And it gives it to me fine. Example 18/10/2006 (October 18, 2006) I then take that date and insert it into another SQL statement which says goto the other table (lets say "reports") and retrieve the record with this date.

This is an example of the error I get.

Error while executing the query;
ERROR:  date/time field value out of range: "18/10/2006 11:23:19 am" 

With the computer configured with a short date of Month/DAY/Year it works fine. "10/18/2006"

Any ideas?

[Wiebe@CARYA]

"asdfg" <x@no.email> wrote in message news:1161196809832-429428@exchange.ni.com...
I am having trouble with an SQL statement in LV7.0. With my machine configured with a Short Date format of Day/Month/Year (Australia)
I ask the database for the timestamp of the most recent record. And it gives it to me fine. Example 18/10/2006 (October 18, 2006) I then take that date and insert it into another SQL statement which says goto the other table (lets say "reports") and retrieve the record with this date.
This is an example of the error I get.
Error while executing the query;ERROR:&nbsp; date/time field value out of range: "18/10/2006 11:23:19 am"&nbsp;
&nbsp;
With the computer configured with a short date of Month/DAY/Year it works fine. "10/18/2006"
&nbsp;
Any ideas?
&nbsp;



If you only use the database for your own LabVIEW applications, don't store dates, store the "seconds since 1904" dubble. It will be much easier in LabVIEW, but more difficult to check results in the database.


Regards,


Wiebe.