[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] problem reading in SQL file with To_Date from Oracle
From:       Alexey Pechnikov <pechnikov () mobigroup ! ru>
Date:       2009-02-27 11:37:28
Message-ID: 200902271437.28260.pechnikov () mobigroup ! ru
[Download RAW message or body]

Hello!

On Friday 27 February 2009 01:17:51 D. Richard Hipp wrote:
> > Then, I ran the .read command in sqlite3 to read in the sql  
> > statements.
> > sqlite doesn't support the TO_Date function.
>
> Please send me an example of the TOAD-generated INSERT statement that  
> includes a TO_Date function.

I did use this functions:

#Access now()
proc now {} {clock format [clock seconds] -format "%Y-%m-%d %H:%M:%S" -gmt 0};
#Read Oracle date format
proc oradate {date} {clock format [clock scan $date] -format "%Y-%m-%d %H:%M:
%S" -gmt 0};

May be possible to add this to SQLite corefuncs?

Best regards.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[prev in list] [next in list] [prev in thread] [next in thread]