Re: [GENERAL] Table Design: Timestamp vs time/date

2000-08-06 Thread Tom Lane
Dale Walker <[EMAIL PROTECTED]> writes: > Having a 'timestamp' field 'CCYY-MM-DD HH:MM:SS.SS' or two separate > fields one for time 'HH:MM:SS.SS' and one for Date 'CCYY-MM-DD'. Go for the timestamp. Otherwise you'll be cursing yourself the first time someone wants to know about "all logins betwe

[GENERAL] Table Design: Timestamp vs time/date

2000-08-05 Thread Dale Walker
I'm currently setting up a table to contain user login/logout information. Just wondered what would be more scalable??better to index,etc... Having a 'timestamp' field 'CCYY-MM-DD HH:MM:SS.SS' or two separate fields one for time 'HH:MM:SS.SS' and one for Date 'CCYY-MM-DD'. most queries will be o