date-time format wrong!!

[Joseph Morgan]

On Dec 11, 2007, at 9:31 AM, Danny Lewkin wrote:

> 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!


I have always had difficulty with this as well. See my notes in Mantis  
ID 0002831:

jojoSATX Mantis quote:
> realbasic rejects datevalue as a valid date
>
> look at it in the debugger of any correct database and the format  
> should be (I think):
> yyyy-mm-dd hh:mm:ss
>
> Any attempts to access the following fail:
> realbasics recordset.field("").datevalue
> recordset.idxfield("").datevalue

Thanks,
joseph