SQL date and time datatype

ODBC Connectivity, ELFs , Windows API etc.

Moderators: Phil Winkler, Graham Smith, Pete Tabord

SQL date and time datatype

Postby Stewart Allen » Tue Oct 09, 2007 1:14 pm

Hi All

This was posted on the DE forum. it seems there is more action over here and the OLEDB issues should be similar.

Does anyone know how to pass correct date AND time values over to an Oracle Date datatype field.

If the date only is sent, then the time portion is understandably 00:00:00.

I need to populate the date and time.

Using a text variable and passing "TO_DATE('2005-10-08 12:00:00', 'YYYY-MM-DD HH24:MI:SS')" does not work.

concat(DateField," ",TimeField) does not work.

using Extended Date and Time variables also do not work.

Any ideas?
Stewart Allen
Posts: 88
Joined: Thu Sep 27, 2007 11:25 am
Has thanked: 0 time
Been thanked: 0 time

Postby Graham Smith » Tue Oct 09, 2007 2:09 pm

I just posted a response over on the DataEase forum.
Graham Smith
DataSmith, Delaware
"For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)
"X-Clacks-Overhead: GNU Terry Pratchett"
User avatar
Graham Smith
Posts: 2501
Joined: Fri Sep 07, 2007 11:31 am
Location: Delaware, USA
Has thanked: 0 time
Been thanked: 1 time

Return to Advanced

Who is online

Users browsing this forum: No registered users and 1 guest