|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: Mercator / Oracle ODBC
Thanks to everyone - I fixed it and it is working great! The correct
format is "CCYY-MM-DD HH:MM:SS".
--- In EDI-L@y..., "Graham Travis" <graham_travis@q...> wrote:
> Which version of Mercator? 5.0 (and I think 2.n) creates dates as
Mercator
> date fields so no conversion is necessary. With earlier versions
the text
> has to be formatted as "CCYY-MM-DD HH:MM:SS" (19 characters)
whereas "DATETOTEXT(currentdate())" gives the date in the system's
default format, e.g. "DD/MM/YY" also you
> should include the time which I think on 1.4.2 needed something
like
> NUMBERTOTEXT(TIMETONUMBER(currenttime())), or just add "
00:00:00". It's
> a long time since I used 1.4.2 so this is all from memory.
>
> I just noticed you mention ODBC. The Mercator native Oracle adaptor
is
> much better than ODBC.
>
> Graham Travis
>
>
>
>
> From: "matthias_edi" <mmatthias@s...>
>
> Tue 09/07/2002 14:09
>
> To: EDI-L@y...
> Cc:
> Subject: [EDI-L] Mercator / Oracle ODBC
>
>
>
>
>
>
> 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:
> EDI-L-unsubscribe@y...
> 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/
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
