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:

Not really WebCat (1997) More on the email templates (1997) [BULK] [WebDNA] Snow Leopard Server install problems (2010) oi ...emailer (2002) Frames and WebCat (1997) Summarizing on two fields (1998) WebCatalog can't find database (1997) So, does anyone have developer editon running on Win XP (2006) BGcolor (1997) protect tag on NT IIS (1997) WebCatalog for guestbook ? (1997) Does webcatalog recognise NULL values? (1998) WebCat2final1 crashes (1997) WCS Newbie question (1997) [SearchString] problem with [search] context (1997) WCS Newbie question (1997) WebCat2.0 [format thousands .0f] no go (1997) webcat and OS 8 (1997) PCS Frames (1997) Quitting WebMerchant ? (1997)