SqlAlchemy&Pymssql and Insert TimeStamp

Discussion in 'Python' started by siouz, Feb 21, 2012.

  1. siouz

    siouz

    Joined:
    Feb 21, 2012
    Messages:
    1
    Likes Received:
    0
    hi
    i am using sqlalchemy 7.5 pymmsql 2.0.0b.

    When I try to insert data in table with a Timestamp column, i get this error :


    However the result shows for example
    (datetime.datetime(2006, 2, 16, 17, 50, 19) which is supposed to be
    2006-02-16 17:50:19.000
    anyway to correct query a date column using pymssql so that it gives
    the correct date format? thanks
     
    siouz, Feb 21, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Michael Hertz
    Replies:
    3
    Views:
    11,288
    Martin Honnen
    Oct 4, 2004
  2. Josh Close
    Replies:
    0
    Views:
    806
    Josh Close
    Jul 22, 2004
  3. saqib@saqibali.org

    How to change pymssql timeout value?

    saqib@saqibali.org, Aug 8, 2005, in forum: Python
    Replies:
    0
    Views:
    720
    saqib@saqibali.org
    Aug 8, 2005
  4. eight02645999@yahoo.com

    pymssql and date format

    eight02645999@yahoo.com, Feb 16, 2006, in forum: Python
    Replies:
    1
    Views:
    1,524
    Steve Holden
    Feb 16, 2006
  5. rc
    Replies:
    3
    Views:
    1,104
    Diez B. Roggisch
    Oct 18, 2007
  6. Tzury Bar Yochay
    Replies:
    3
    Views:
    1,273
    Rob Williscroft
    Mar 24, 2008
  7. Massi
    Replies:
    0
    Views:
    1,044
    Massi
    Jul 21, 2010
  8. Hegedüs, Ervin

    Insert trusted timestamp to PDF

    Hegedüs, Ervin, Dec 7, 2011, in forum: Python
    Replies:
    10
    Views:
    1,367
    marco.rucci@gmail.com
    Dec 8, 2011
Loading...