Re: Oracle Newbie (coupla quick ones!)

Ed

Try to_date(sysdate,'DD-MON-YYYY HH:MI:SS')

Gary.
ed wrote in message <38a7b746$0$32620_at_motown.iinet.net.au>...
>Hi all,
> I have a couple of quick questions. I use Oracle 8.1.5, with vb6,
>connected using the Oracle ODBC driver through ADO. Cool, this SEEMS to
>work, however, I have a couple of questions/issues.
>
>a.Oracle date format in SQL Strings
>What is the format required to save a date AND time into an Oracle DB?
>We know dd-MMM-yyyy will save date, but what about time??? I tried
>dd-MMM-yyyy hh:nn, but this fails. Also, do you need the to_date function?
>
>b.Joining tables (outer joins)
>I want ALL rows from tblname1, and only matching rows from tblname2
>I have seen 2 different ways to do this. Which is the RIGHT way?
>1.tblname1.keyfield(+) = tblname2.fkeyfield
>2.tblname1.keyfield *= tblname2.fkeyfield
>Also, does this have to be done with a where clause? (rather than 'inner
>join') I get syntax errors with the 'inner join' command.
>
>
>Thanks in advance...
> Ed.
>
>
Received on Mon Feb 14 2000 - 07:57:02 CST