Re: [WebDNA] Storing time data in a database

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113161
interpreted = N
texte = 749 --Apple-Mail=_E5F4EBA7-18E8-4D3C-A77E-79692C1B2BBA Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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: >=20 > Hi, >=20 > I will updating a WebDNA database from a tab delimited file on a daily = basis. >=20 > The data file I am importing has a date/time stamp styled as: = 2016-11-05 1207 >=20 > I am already breaking the date and time up and formatting the date as = 11/05/2016 to store it in the db. >=20 > 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.=20= >=20 > Thanks >=20 > Dale >=20 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_E5F4EBA7-18E8-4D3C-A77E-79692C1B2BBA Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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 <dtherio@gmail.com> = 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 --Apple-Mail=_E5F4EBA7-18E8-4D3C-A77E-79692C1B2BBA-- . 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)
749 --Apple-Mail=_E5F4EBA7-18E8-4D3C-A77E-79692C1B2BBA Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii 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: >=20 > Hi, >=20 > I will updating a WebDNA database from a tab delimited file on a daily = basis. >=20 > The data file I am importing has a date/time stamp styled as: = 2016-11-05 1207 >=20 > I am already breaking the date and time up and formatting the date as = 11/05/2016 to store it in the db. >=20 > 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.=20= >=20 > Thanks >=20 > Dale >=20 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_E5F4EBA7-18E8-4D3C-A77E-79692C1B2BBA Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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 <dtherio@gmail.com> = 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 --Apple-Mail=_E5F4EBA7-18E8-4D3C-A77E-79692C1B2BBA-- . WebDNA Development

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:

db updating? (2000) Not carrying Zero (2000) [ShowCart] and GET vs. POST (1997) PCS Emailer's role ? (1997) PROBLEM (1997) [OT] Indexing of dynamic web sites (2003) Protect Tag and Groups (1998) domain in cookie (2006) New public beta available (1997) process SSI (1998) Search/sort in URL Was: GuestBook example (1997) PIXO with cometsite ... and/or other plugins (1998) security (1997) stuck time (1998) [WebDNA] Data Type Bool (2009) [ModDate] & [ModTime] ? (1997) Date Formats (1997) trying to filter out various words from user entered text (2004) Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997) Quitting WebMerchant ? (1997)