[sqlalchemy] Re: Is there any potential problem to store datetime as strings in one column?

2015-03-30 Thread Bao Niu
On Monday, March 23, 2015 at 7:53:31 AM UTC-7, Jonathan Vanasco wrote: On Sunday, March 22, 2015 at 7:01:35 PM UTC-4, Bao Niu wrote: Also because sql datetime datatype doesn't persist timezone information. Therefore, I tried to store all the time information as strings. If your

[sqlalchemy] Re: Is there any potential problem to store datetime as strings in one column?

2015-03-30 Thread Jonathan Vanasco
On Monday, March 30, 2015 at 9:06:48 PM UTC-4, Bao Niu wrote: To make sure that I understand it right, did you mean hybrid attribute methods when you mentioned property methods here? Thanks No, just simple property methods. A super-simple first Minimum Viable Product/iteration might be:

[sqlalchemy] Re: Is there any potential problem to store datetime as strings in one column?

2015-03-23 Thread Jonathan Vanasco
On Sunday, March 22, 2015 at 7:01:35 PM UTC-4, Bao Niu wrote: Also because sql datetime datatype doesn't persist timezone information. Therefore, I tried to store all the time information as strings. If your database doesn't support timezones, I think it would be easiest to convert