Home » Developer & Programmer » Forms » What is wrong???
What is wrong??? [message #125461] Sat, 25 June 2005 21:34 Go to next message
mlodymaytek
Messages: 9
Registered: June 2005
Location: poland
Junior Member
Oracle 9i, Developer suit 9i, win xp prof.,
:kierowca_pojazd.czas := :kierowca_pojazd.data_zdania - :kierowca_pojazd.data_obsady;

:kierowca_pojazd.czas - type datetime
:kierowca_pojazd.data_zdania - datetime
:kierowca_pojazd.data_obsady - type datetime

and I can not compilate this. Is say that wrong expression type.
I want to subtract two type (hh24:mi) and store in :kierowca_pojazd.czas

Report message to a moderator

Re: What is wrong??? [message #125471 is a reply to message #125461] Sun, 26 June 2005 12:36 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
subtracting a date from another date yields a number, not a date.

hth

Report message to a moderator

Re: What is wrong??? [message #125474 is a reply to message #125471] Sun, 26 June 2005 14:14 Go to previous message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
Perhaps you need an INTERVAL DAY TO SECOND datatype instead of a date.

Report message to a moderator

Previous Topic: Developer 9i Ds Problems.
Next Topic: Parsing XML file using Oracle Forms?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:11:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.