texte = 745 --001a113b005cc74f6405409ce91f Content-Type: text/plain; charset=UTF-8 Hi, I will updating a WebDNA database from a tab delimited file on a daily basis. The data file I am importing has a date/time stamp styled as: 2016-11-05 1207 I am already breaking the date and time up and formatting 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 secondary 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. Thanks Dale --001a113b005cc74f6405409ce91f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,
I will updating a WebDNA database f= rom a tab delimited file on a daily basis.
The dat= a file I am importing has a date/time stamp styled as:=C2=A02016-11-05 1207=
I am already breaking the date and time up and fo= rmatting 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= secondary 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 ask= ing for the most flexibility and compatibility with WebDNA contexts.=C2=A0<= /div>
Thanks
Dale
=
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --001a113b005cc74f6405409ce91f-- .
Associated Messages, from the most recent to the oldest:
745 --001a113b005cc74f6405409ce91f Content-Type: text/plain; charset=UTF-8 Hi, I will updating a WebDNA database from a tab delimited file on a daily basis. The data file I am importing has a date/time stamp styled as: 2016-11-05 1207 I am already breaking the date and time up and formatting 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 secondary 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. Thanks Dale --001a113b005cc74f6405409ce91f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi,
I will updating a WebDNA database f= rom a tab delimited file on a daily basis.
The dat= a file I am importing has a date/time stamp styled as:=C2=A02016-11-05 1207=
I am already breaking the date and time up and fo= rmatting 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= secondary 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 ask= ing for the most flexibility and compatibility with WebDNA contexts.=C2=A0<= /div>
Thanks
Dale
=
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --001a113b005cc74f6405409ce91f-- .
dale
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
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...
Related Readings:
Frames and WebCat (1997)
Test (2006)
Custom WebCat Prefs ... (1997)
More than one db with the same namn (was: WC2f3) (1997)
Tax on shipping (1998)
Adding Message to Order (1997)
Passing Variable (was How to add product size) (1997)
RE: [countChars] from