yes, any ideas help. just looking for the best way. thank you !!
> -----Original Message-----
> From: Mark Charshaf [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 14, 2002 1:08 PM
> To: Kipp, James
> Cc: Dbi-Users
> Subject: RE: best way to insert date/time into oracle table
>
>
> Some date inserts I have experience with regarding Oracle and
> mssql (if this
> helps).
>
> Mark
>
> --Oracle
> insert into order_details (OrderID, ProductID, UnitPrice, Quantity,
> Discount, OrderDate, ProductName)
> VALUES (5,1,1,1,1,TO_DATE ('4/01/1953', 'MM/DD/YYYY'),'name') ;
>
> --mssql
> insert into "order details" (OrderID, ProductID, UnitPrice, Quantity,
> Discount, OrderDate, ProductName)
> VALUES (5,1,1,1,1,'4/01/1953','name') ;
> -or-
> insert into "order details" (OrderID, ProductID, UnitPrice, Quantity,
> Discount, OrderDate, ProductName)
> VALUES (5,1,1,1,1,'apr 1, 1953','name') ;
>
>
>