current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.

Join them; it only takes a minute:

Sign up
Join the Stack Overflow community to:
  1. Ask programming questions
  2. Answer and help your peers
  3. Get recognized for your expertise
up vote 1 down vote favorite

I have a table in PostgreSQL created by SQLAlchemy just like that:

Column('dt_index_tex', DateTime)

If I insert a date like '21-01-2014', when querying I get the date in different format:

SELECT dt_index_tex from table;
    dt_index_tex        |        
------------------------+
 2014-01-21 00:00:00    |

how could i query in DMY format ?

I know in PostgreSQL I have the to_char function, but I want something to do with SQLAlchemy, so I don't have to change the format all times I query the table. I guess I have to try a different way of creating the table, but don't know what is missing.

share|improve this question
3  
What is the code you are using in SQLAlchemy to query the date? If you create it using SQLAlchemy and query through SQLAlchemy, SQLAlchemy should handle the formatting for you and return it as a datetime object (not a string). – Mark Hildreth Jan 22 '14 at 16:42
    
you're right dude, so silly, thank you ! – user1538560 Jan 22 '14 at 18:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.