Try this instead :
Have your date field in the database to be a string one. Then the
following code works like a charm.
when you insert :
dim mydate as new date
rec.datecolumn("DOB")=mydate.sqldate (sqldatetime)
dim mydate as new date
and when you read from it
mydate.sqldate = rs.column("DOB").value
Easy as that,
Trausti
On 24.7.2006, at 08:41, Jeff Ayling wrote:
Hi all,
I am trying to use the DateColumn to store a date and time value
but the time is not being recorded.
In the RB docs is says it will store a date as "it converts to SQL
in full form (e.g., "2000-5-30 18:54:00")"
However my records look like this: 2006-07-24 00:00:00 without the
correct time
This is all I am doing to capture the date - do I need to do
anything else to mydate to make it pass the full date and time?
Dim mydate as New Date
rec.DateColumn("DOB")=mydate
Thanks
Jeff
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
