Dates, postgresql and pygresql
When I want to write a date to a postgres table in the following query
(using python and pygresql)
INSERT INTO lidmate VALUES (3157,864,'ACKERMAN','MARTHINUS THEODORUS','MNR',
'','ACKERMAN','','O','M','B','','','17/06/1997','19/08/1997')
the following error message occurs:
Traceback (innermost last):
File "<stdin>", line 78, in ?
File "<stdin>", line 71, in skryf_data
ValueError: WARN:Bad date external representation
I have the following lines in my .bashrc to set the locale:
LANG='en_GB'
export LANG
I also did a
os.system("set DateStyle to 'SQL,European'")
in the program to see if that will solve the problem, but it made no
difference.
Can somebody help, please?
Johann.
------------------------------------------------
Johann Spies
jhspies@alpha.futurenet.co.za
Windsorlaan 19
Pietermaritzburg
3201
Suid Afrika (South Africa)
Tel/Faks Nr. +27 331-46-1310
--
TO UNSUBSCRIBE FROM THIS MAILING LIST: e-mail the word "unsubscribe" to
debian-user-request@lists.debian.org .
Trouble? e-mail to templin@bucknell.edu .
Reply to: