Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
date problems
- From: ivan marchesini <marchesini(at)unipg(dot)it>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: date problems
- Date: Thu, 30 Aug 2007 15:01:03 +0200
Dear PG users, I have an access db and I'm trying to pass all to postgres I have used mdbtools to export the schema and all went quite well. then I exported the single tables... to csv.. a lot of table have some timestamp fields containing data as DD/MM/YYYY, and I'm no able to copy this table into postgres... because it needs YYYY/MM/DD... I used \copy... Which is the best solution for this problem... many thanks Ivan -- Ti prego di cercare di non inviarmi files .doc, .xls, .ppt, .dwg. Preferisco formati liberi. Please try to avoid to send me .doc, .xls, .ppt, .dwg files. I prefer free formats. http://it.wikipedia.org/wiki/Formato_aperto http://en.wikipedia.org/wiki/Open_format Ivan Marchesini Department of Civil and Environmental Engineering University of Perugia Via G. Duranti 93/a 06125 Perugia (Italy) e-mail: marchesini(at)unipg(dot)it ivan(dot)marchesini(at)gmail(dot)com tel: +39(0)755853760 fax (university): +39(0)755853756 fax (home): +39(0)5782830887 jabber: geoivan73(at)jabber(dot)org
- Follow-Ups:
- Software CASE - PostgreSQL
- From: AlphaÔmega
- Re: date problems
- From: Roberto Spier
- Re: date problems
- From: Michael Glaesemann
- Re: date problems
- From: A. Kretschmer
- Software CASE - PostgreSQL
- Prev by Date: Re: Postgres 7.4 function
- Next by Date: Re: date problems
- Previous by thread: Postgres 7.4 function
- Next by thread: Re: date problems
- Indexes: