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:

[CART] (1997) Hideif not working? (2001) ErrorMessages.db suggestion (1997) Problems appending to database (1997) U&P IIS concept (1998) off topic - dna snipets (1997) strange math (2004) Template Cache problem (2000) Three new problems ... (1997) My X-Mas Wish (1999) WCS Newbie question (1997) how to construct a search for not this entire string? (2000) Access Denied! But why? (1997) all db's in one folder and protected (1998) Redirect in 4.0 (2000) Date field search needs ... (1998) no global [username] or [password] displayed ... (1997) Separate SSL Server (1997) [WebDNA] UK Based hosts (2018) Security (2002)