Re: [WebDNA] Storing time data in a database

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113169
interpreted = N
texte = 757 --001a113d6e806d57d30540f64523 Content-Type: text/plain; charset=UTF-8 Stuart and Ken Thank you. My earlier question that Ken replied to was for me a different question, at least to my thought processes. It makes a lot more sense now. That is what I ended up doing. I had to break up the time and date (they were stored as one field in the CSV). The Date was also in yyyy-mm-dd format so I broke it up and re-assembled it as mm/dd/yyyy then stored it as you described. I didn't see a way to use the existing formatting abilities to automatically convert from the format supplied to what I needed. Dale On Sun, Nov 6, 2016 at 5:13 PM, WebDNA Development wrote: > Why not store in in two formats > > mm/dd/yyy & [MATH]{mm/dd/yyyy}[/MATH] > > hh:mm:ss & [MATH]{hh:mm:ss}[/MATH] > > Then you can do anything you want with it at a later time & date (pardon > the pun). > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 6 Nov. 2016, at 18:32, dale wrote: > > 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 --001a113d6e806d57d30540f64523 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Stuart and Ken

Thank you. My earlier qu= estion that Ken replied to was for me a different question, at least to my = thought processes. It makes a lot more sense now.

= That is what I ended up doing. I had to break up the time and date (they we= re stored as one field in the CSV). The Date was also in yyyy-mm-dd format = so I broke it up and re-assembled it as mm/dd/yyyy then stored it as you de= scribed. I didn't see a way to use the existing formatting abilities to= automatically convert from the format supplied to what I needed.

=C2=A0Dale

On Sun, Nov 6, 2016 at 5:13 PM, WebDNA Development <= webdna@idfk.com.au> wrote:
=
Why not store in in two formats
mm/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).



Kind r= egards

Stuart Tremain
IDFK Web Developme= nts
AUSTRALIA


<= /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

Thanks

Dale

<= br>
--------------------------------------------------------- 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: suppo= rt@webdna.us

--------------------------------------------------------- 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: suppo= rt@webdna.us
--------------------------------------------------------- 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 --001a113d6e806d57d30540f64523-- . 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)
757 --001a113d6e806d57d30540f64523 Content-Type: text/plain; charset=UTF-8 Stuart and Ken Thank you. My earlier question that Ken replied to was for me a different question, at least to my thought processes. It makes a lot more sense now. That is what I ended up doing. I had to break up the time and date (they were stored as one field in the CSV). The Date was also in yyyy-mm-dd format so I broke it up and re-assembled it as mm/dd/yyyy then stored it as you described. I didn't see a way to use the existing formatting abilities to automatically convert from the format supplied to what I needed. Dale On Sun, Nov 6, 2016 at 5:13 PM, WebDNA Development wrote: > Why not store in in two formats > > mm/dd/yyy & [math]{mm/dd/yyyy}[/MATH] > > hh:mm:ss & [math]{hh:mm:ss}[/MATH] > > Then you can do anything you want with it at a later time & date (pardon > the pun). > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 6 Nov. 2016, at 18:32, dale wrote: > > 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 > > > --------------------------------------------------------- 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 > > > --------------------------------------------------------- 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 --001a113d6e806d57d30540f64523 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Stuart and Ken

Thank you. My earlier qu= estion that Ken replied to was for me a different question, at least to my = thought processes. It makes a lot more sense now.

= That is what I ended up doing. I had to break up the time and date (they we= re stored as one field in the CSV). The Date was also in yyyy-mm-dd format = so I broke it up and re-assembled it as mm/dd/yyyy then stored it as you de= scribed. I didn't see a way to use the existing formatting abilities to= automatically convert from the format supplied to what I needed.

=C2=A0Dale

On Sun, Nov 6, 2016 at 5:13 PM, WebDNA Development <= webdna@idfk.com.au> wrote:
=
Why not store in in two formats
mm/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).



Kind r= egards

Stuart Tremain
IDFK Web Developme= nts
AUSTRALIA


<= /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

Thanks

Dale

<= br>
--------------------------------------------------------- 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: suppo= rt@webdna.us

--------------------------------------------------------- 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: suppo= rt@webdna.us
--------------------------------------------------------- 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 --001a113d6e806d57d30540f64523-- . 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:

Mac app. that converts e-mails (2000) Webcat Manual and TeaRoom Examples Uses Different Examples. (1997) email program problem (1998) Fedora Core 6 (2007) Suggestions (1998) shipcost (1997) Reversed words (1997) WebCatalog dying in WebTen Revisited (1998) Order problem (1998) New command suggestion (1997) SIMS setup (1998) [searchString] (1997) WC2b15 File Corruption (1997) WC2b12: Yes, Formulas.db is for real (1997) TCP Connect (1999) WebCatalog 3.0.8 is on FTP... (2000) Resume Catalog ? (1997) WebCat2 Append problem (B14Macacgi) (1997) Date search - yes or no (1997) Multiple catalog databases and showcart (1997)