Exporting smalldatetime fields to PostgreSQL from SQL server 1

[tharas]

Hello all,

I am engaged in a work of porting a MS SQL server database to PostgreSQL. I am using PostgreSQL 8.0 and both the databases are in Windows. I have a smalldatetime field in one of the tables in which the data is stored in the format dd/MM/yyyy. But when I am exporting this field to PostgreSQL using the Data Transformation Services (DTS), the values are ported to PostgreSQL database in the format yyyy/MM/dd.

I have tried the following:

1. The regional settings of the system is set as dd/MM/yyyy for short date format
2. The DateStyle value of the postgreSQL database is set as DMY,ISO.

Yet the problem persists.

Please help. Thanks

...thara

 

[aftertaf]

try adding new data to your postgres table without the dts, and see if it is because of the table configuration, or if it is the dts/odbc that is messing things up

Aftertaf

Sometimes it just needs a good kicking.