SYSDATE for a default value
From: David Rabsch <DRabsch_at_palliser.ca>
Date: Mon, 28 Jun 1999 09:32:03 -0500
Message-ID: <37778763.509CF5FC_at_palliser.ca>
Hi, I'm a newbie, so please excuse this if it's an elementary question.....
Date: Mon, 28 Jun 1999 09:32:03 -0500
Message-ID: <37778763.509CF5FC_at_palliser.ca>
Hi, I'm a newbie, so please excuse this if it's an elementary question.....
I want to have the default value in a table be the current date and time, and found the function SYSDATE. Seems like the right thing to do. My question is, how do I put the result of SYSDATE into the field? What's the correct syntax? Do I use a trigger on the table, and if so, when? I've already got one trigger to automatically increase a value in an ID field by one every time a new field is inserted and it works great, but I tried to do the same thing with the SYSDATE function with no luck. I'm coming over from Access, so my sql (and esp. PL/SQL) is horrible. Thx for the help.
Received on Mon Jun 28 1999 - 16:32:03 CEST