Jump to content

Archived

This topic is now archived and is closed to further replies.

natalieG

Date Sort

Recommended Posts

I have a date column that I plan to store as a string, ie 'jan 12,1996' I want order by that
column. Can this be done. or should add a column to store the secondsfromEpoch in the second column
and get the date strin g when I need it.

Thanks,

Jennifer Good

Share this post


Link to post
Share on other sites
if you store the date in a column of data type date or datetime or timestamp or even as a number datatype (holding the unix timestamp) then you can sort by that column. but if you store the date as a regular string datatype, like varchar, blob, whatever, then it will just sort it alphabetically.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.