in reply to Database time or just time

I know that Oracle has a special value called SysDate that returns the current date and time.
In Oracle, you could do: 
INSERT INTO mytable (user_id, subject, message, message_date)
             VALUES ('Bob', 'Lunch', 'Anyone want lunch?', SysDate)

[download]

Before you write code to format the date in Perl, you might check whether Access has something similar.

Replies are listed 'Best First'.
Re: Re: Database time or just time
by gharris (Beadle) on Dec 05, 2000 at 21:45 UTC
    The function you are looking for in Access would simply be 'Now()' 
    INSERT INTO mytable (user_id, subject, message, message_date)
      VALUES ('Bob', 'Lunch', 'Anyone want lunch?', NOW())

    [download]
    --Glenn
[reply]
[d/l]

In Section Seekers of Perl Wisdom