So if I put $date = :mydate after I loaded the variable and disconnected from the database then it would pass the localtime in HH::MM::SS format into the $date scalar?
thanks for the help, John -----Original Message----- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 4:30 PM To: John Deretich Cc: Perl-Win32-Admin-Request \(E-mail\) Subject: Re: sql statements yes and yes. you are pulling the current oracle system date from the dummy table dual, and loading it into a user variable. in essence, you are getting the localtime according to the oracle system you query. -~.-~.-~.-~.-~.-~.-~.-~.-~.-~ -~ -~ Cliff Frensley -~ [EMAIL PROTECTED] -~ Seattle, WA -~ -~ -. On Thu, 20 Feb 2003, John Deretich wrote: > Hi > > does anyone understand > this sql statement, select sysdate into :mydate from dual, > using the dbi module? And is the :mydate a variable where the > sysdate gets loaded into? > > regards, > > John > _______________________________________________ > Perl-Win32-Admin mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
