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:

'does not contain' operator needed ... (1997) using showpage and showcart commands (1996) Can WC remember people? (1998) Problem with empty form-variables in [search] (1998) shipping calculations, lookup command (1997) WebCat2 - Getting to the browser's username/password data (1997) Disappearing data [OT] (2002) changing banners on a page without refresh? (2000) Help! WebCat2 bug (1997) many-to-one problem (1998) database problems (1999) [WebDNA] Searching Possible Bug (2009) email [title] (1997) Shownext on AOL (2003) Follow-Up to: Removing [showif] makes a big difference in speed (1997) HELP WITH DATES (1997) [SHOWIF AND/OR] (1997) WebCat2b13MacPlugIn - [include] (1997) EMailer - WebSTAR V - OSX - WebDNA (2003) filemaker - orderfile (1997)