On Oct 19, Sean Berry wrote: > I am using MySQLdb to connect to a database and retrieve a timestamp > from a table. The problem is I want the timestamp as a long, > unformatted and all. > > In the table I have a timestamp like this > 20051019111617 > > But, when I retrieve the value and print it I get > 2005-10-19 11:16:17 > > I want the numeric version, not the converted date. Any suggestions?
Without giving any thought to MySQLdb or datetime, the simplest thing that comes to mind is >>> import re >>> re.sub('( |-|:)', '', ' 2005-10-19 11:16:17') '20051019111617' -- _ _ ___ |V|icah |- lliott http://micah.elliott.name [EMAIL PROTECTED] " " """ -- http://mail.python.org/mailman/listinfo/python-list