search

angoca / log4db2

A logging utility like log4j for IBM Db2 SQL PL
https://angoca.github.io/log4db2/
BSD 2-Clause "Simplified" License
7 stars 2 forks source link

Force date format when creating TravelTime tables #51

Closed angoca closed 10 years ago

angoca commented 10 years ago

-- TODO set date format to prevent issues with inserting. https://github.com/angoca/log4db2/blob/master/src/main/sql-pl/TablesTimeTravel.sql

angoca commented 10 years ago

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0053732.html

angoca commented 10 years ago

Format to insert http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0007107.html

angoca commented 10 years ago

Varchar http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0007110.html

angoca commented 10 years ago

Finally it was solved with DATE: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0000784.html