date-time format wrong!!

[Danny Lewkin]

It's even worse than that!!

A string from RB, stored in the DB through a cursor, is also stored  
in the wrong way!!
What I mean is, the string in RB is 2007-12-11 14:35 (on debug  
level), when I store it in the DB and do a select, it shows as  
11-12-2007 14:35 !!

The function NOW() should NOT be influenced by de dateformat on a pc!
It should look at the dateformat of the DB, and work with that setting!
Well, in my opinion anyway!

Greetz,

Danny


Op 11-dec-07, om 16:18 heeft william humphrey het volgende geschreven:

> How is the system date on your computer set?
>
> On 12/11/07, Danny Lewkin <daniel.lewkin at cognosis.be> wrote:
>>
>> Hi List, Ruslan,
>>
>> The dateformat in our DB is set to YYYYMMDD.
>> But when we use the function NOW(), it stores the date als
>> DDMMYYYY.... WHY?????
>>
>> Greetz,
>>
>> Danny
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>
>
>
> -- 
> http://www.bluewatermaritime.com
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina