|
=Why not store in in two formatsmm/dd/yyy & [math]{mm/dd/yyyy}[/MATH]<=div>hh:mm:ss & [math]{hh:mm:ss}[/MATH]Then yo=u can do anything you want with it at a later time & date (pardon the p=un).<=/span>------------------------------On 6 Nov. 20=16, at 18:32, dale <dtherio@gmail.com> wrote:Hi,I will updating a WebDNA database from a t=ab delimited file on a daily basis.The data file =I am importing has a date/time stamp styled as:=C2=A02016-11-05 1207<=div>I am already breaking the date and time up and formattin=g the date as 11/05/2016 to store it in the db.My= question is about the time. Down the road we might had need to do a second=ary sort based on time (primary on date). Should I store it as shown above =then do any formatting for display only (e.g. 12:07 PM). I'm asking for= the most flexibility and compatibility with WebDNA contexts.=C2=A0 ThanksDale<=br>---------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/ talk@webdna.us Bug Reporting: suppo=rt@webdna.us
DOWNLOAD WEBDNA NOW!
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...