Paul W. Reilly wrote:
>
> MaxDB Community Member,
>
> I have been trolling through all the post and documentations
> and am not
> having much luck with finding the proper way to handle date insertion.
>
> When I do this: insert into temp_x (date_) values ('2004-10-04')
> it works fine, but I would prefer to handle dates in an
> Oracle fashion with:
> ... values (to_date('10-04-2004','mm/dd/yyyy')) Or something
> other and
> having to use a format that will require me to write apps that have to
> reformat all dates for the users.
If you like things as they are in Oracle, why don't you use the sqlmode Oracle?
http://www.mysql.com/documentation/maxdb/07/a1637ea57411d2a97100a0c9449261/frameset.htm
Depending on the type of application (ODBC, JDBC, perl, C,...) you have to specify
that you
want to use this sqlmode. Please have a look in the description of the corresponding
interfaces.
Elke
SAP Labs Berlin
>
> Does anyone have the answer I can't find? Is there something
> I missed in
> the docs?
>
> Paul Reilly
> [EMAIL PROTECTED]
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.620 / Virus Database: 399 - Release Date: 3/11/2004
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
