[WebDNA] Storing time data in a database

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113157
interpreted = N
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:

    
  1. Re: [WebDNA] Storing time data in a database (dale 2016)
  2. Re: [WebDNA] Storing time data in a database (WebDNA Development 2016)
  3. Re: [WebDNA] Storing time data in a database (Kenneth Grome 2016)
  4. [WebDNA] Storing time data in a database (dale 2016)
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:

emailer don't work (1998) Serial Number Question (1997) Calendar (1997) Authenticate (1997) CC and Europe (1999) Forumulas.db & Variables (2002) Using Applescript to process WebCatalog functions (1998) WebCat2 beta 11 - new prefs ... (1997) [Sum] function? (1997) Tech support (2000) ReturnRaw context (1997) WebCat2: Formulas.db question (1997) Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003) Too Many Items found (2000) [SearchString] problem with [search] context (1997) F2 to F3 rocky transition (1997) WebCatb15 Mac CGI -- [purchase] (1997) search for non-unique question (2001) [Announce]: Web server security and password protection (1997) Multiple fields on 1 input (1997)