Talk:Converting from other Databases to PostgreSQL

From PostgreSQL wiki

Jump to: navigation, search

In the Microsoft Access section, the instructions for mdb-tools says to use the following to define the date format: '%%Y-%%m-%%d %%H:%%M:%%S'. However, in Bash this passes the string with double-%s and mdb-tools does not recognize it as a valid date format, and then in the output files all of the dates appear literally as '%%Y-%%m-%%d %%H:%%M:%%S'.

I think the date spec in the two shell script examples should be changed to the following, which worked for me:

'%Y-%m-%d %H:%M:%S'
Personal tools