Re: Populating 10G XE table with time AND date through VB.Net

From: Dave Baker <newsgroup_poster_at_jodael.com>
Date: Fri, 24 Mar 2006 11:39:43 +0800
Message-ID: <6dq622pod530clp2mjn0jkv5oda31s5fva@4ax.com>

On 23 Mar 2006 07:17:50 -0800, "Carlos" <miotromailcarlos_at_netscape.net> wrote:

>>>Insert into Vessel_Data (GPS_Date) Values ('19-Mar-2006 12:34:38')
>
>Never, ever rely on implicit datatype conversions:
>
>Insert into Vessel_Data (GPS_Date) Values (TO_DATE('19-Mar-2006
>12:34:38','DD-Mon-YYYY hh24:mi:ss'))

excellent - exactly what I was after.

Date still shows in the Oracle GUI without the time, but when I extract it back through VB I can see that the time has been preserved, which is what I am concerned about.

Thanks,

Dave Received on Thu Mar 23 2006 - 21:39:43 CST