Oracle date time

From: <saschac_at_my-deja.com>
Date: Mon, 11 Oct 1999 17:22:38 GMT
Message-ID: <7tt6cf$4v6$1@nnrp1.deja.com>

Hello all, I am trying to get out the time part of a date field. I know I can do such a thing like [select to_char(lastmodifiedon,'dd-mon-yy hh24:mi:ss') from tblobject where id=7957] and that works but I need to be able to do this in a stored procedure.

here is a fragment of my pl/sql procedure

It works fine if i remove the to_char part but i need the time

dLastModifiedOn out date
vtblObject tblObject%ROWTYPE;
select * into vtblObject from tblObject where id=idxx; dLastModifiedOn:=to_char(vtblObject.LastModifiedOn,'dd-mmm-yyyy hh24:mi:

Any suggestions please. I would like the dLastModifiedOn to stay as a date.

Many thanks to you all

Sascha Curzon
Victoria & Albert Museum
London
England

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 11 1999 - 12:22:38 CDT