Inserting time value into table

[AM Matula <amatula@OIT.UMASS.EDU>]

Hi all

A coworker working on a Convoy project (Convoy creates SQRs) needs to insert
a time value (such as 09:15) into a PS table with a variable type of TIME

In the past I have done this within the SQL statement using the TO_DATE
function.

Convoy unfortunately cannot do this, at least not easily (that I am aware of
anyway!)

I thought I could use PS's "Convert to date" functions in datetime.sqc but I
haven't one that is applicable.

I tried a manaul test assigning a value of '01-JAN-1900_11:15:00_AM' to a
date variable declared using DECLARE-VARIABLE and then inserting into the
field.  I thought this was native format that but received a message this
wasn't in an acceptable format:

ORA-01830: date format picture ends before converting entire input string

However if I use '01-JAN-1900' that works!

Any suggestions on how to get time value inserted without needing to use
TO_DATE in the SQL statement?



I receive this in digest format so if you can cc me in on any responses, I'd
greatly appreciate it!

Have a great day!
Anne-Marie


-- - -- - -- - -- - -- - -- - -- - -- - -- - -- - --
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
University of Massachusetts
740 N. Pleasant St
OIT-LGRC A247
Amherst, MA  01003-9306
Phone: 413/577-0685
Fax: 413/545-2150
`