|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: Mercator / Oracle ODBC
Michaels,
I think I also had a problem trying to use the CURRENTDATETIME() function
recently trying to map to Access ODBC.
I don't remember the details.
The FROMDATETIME function worked fine:
FROMDATETIME(CURRENTDATE(),"{MM/DD/CCYY}") and FROMDATETIME(CURRENTTIME(),
"{HH:MM:SS}" )
Dean Stynsberg (The EDI Guy)
1615 Manning Ave. S.
Afton, MN 55001
651-436-2733
----- Original Message -----
From: <
To: "matthias_edi" <
Cc: <
Sent: Tuesday, July 09, 2002 8:25 AM
Subject: Re: [EDI-L] Mercator / Oracle ODBC
> With using version 1.4.x or earlier, you will have to manually format the
> date to this format CCYY-MM-DD<sp>HH:MM:SS with <sp> being a space
> character (hex 20). Since the default date string on a text field is
> YYMMDD, you will have to use the LEFT(), RIGHT() and MID() functions to do
> this
>
> ie
>
> ="20"+LEFT(DATETOTEXT(CURRENTDATE()),4)+"-"+MID(DATETOTEXT(CURRENTDATE
> ()),2)+"-"+RIGHT(DATETOTEXT(CURRENTDATE()),2) - then do the same for the
> time concantenated on this string
>
> Using version 5 or later, when you create your type tree, it should
> automatically format the item properties to a date time with the format as
> indicated as above, and then all you will need to use the
CURRENTDATETIME()
> function to return the proper date.
>
> Hope this helps
>
>
>
> "matthias_edi"
> <mmatthias@synes To:
> isintl.com> cc:
> Subject: [EDI-L] Mercator /
Oracle ODBC
> 07/09/02 08:09
> AM
>
>
>
>
>
>
> I need help with mercator and writing directly to a database.
>
> I am trying to write a map in Mercator that will update Oracle
> tables. Everything works until I get to the dates. I have created
> the type tree using the Database Editior and it sets the date fields
> as TEST (19). When I try to write DATETOTEXT(currentdate()) I get a
> database error. Does anyone have any suggestions?
>
>
>
>
> To unsubscribe from this group, send an email to:
>
> Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
> <OFF-TOPIC>
> Access the list online at: http://groups.yahoo.com/group/EDI-L
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> --------------------------------------------------------------------------
-
> This message (including any attachments) is confidential and may be
> privileged. If you have received it by mistake please notify the sender by
> return e-mail and delete this message from your system. Any unauthorised
> use or dissemination of this message in whole or in part is strictly
> prohibited. Please note that e-mails are susceptible to change.
> ABN AMRO Bank N.V. (including its group companies) shall not be liable for
> the improper or incomplete transmission of the information contained in
> this communication nor for any delay in its receipt or damage to your
> system. ABN AMRO Bank N.V. (or its group companies) does not guarantee
that
> the integrity of this communication has been maintained nor that this
> communication is free of viruses, interceptions or interference.
> --------------------------------------------------------------------------
-
>
>
>
>
> To unsubscribe from this group, send an email to:
>
> Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
<OFF-TOPIC>
> Access the list online at: http://groups.yahoo.com/group/EDI-L
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
