Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.mysql > #5358 > unrolled thread
| Started by | richard <noreply@example.com> |
|---|---|
| First post | 2014-06-20 10:20 -0400 |
| Last post | 2014-06-22 08:45 +0200 |
| Articles | 20 on this page of 90 — 18 participants |
Back to article view | Back to comp.databases.mysql
Putting it all together richard <noreply@example.com> - 2014-06-20 10:20 -0400
Re: Putting it all together Evan Platt <evan@theobvious.espphotography.com.invalid> - 2014-06-20 08:11 -0700
Re: Putting it all together richard <noreply@example.com> - 2014-06-20 11:24 -0400
Re: Putting it all together Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-20 17:15 +0000
Re: Putting it all together Evan Platt <evan@theobvious.espphotography.com.invalid> - 2014-06-20 20:01 -0700
Re: Putting it all together Jürgen Exner <jurgenex@hotmail.com> - 2014-06-20 08:21 -0700
Re: Putting it all together Norman Peelman <npeelman@cfl.rr.com> - 2014-06-20 21:06 -0400
Re: Putting it all together Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-21 03:02 +0000
Re: Putting it all together Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-21 03:09 +0000
Re: Putting it all together Jürgen Exner <jurgenex@hotmail.com> - 2014-06-20 20:13 -0700
Re: Putting it all together richard <noreply@example.com> - 2014-06-20 23:34 -0400
Re: Putting it all together Jürgen Exner <jurgenex@hotmail.com> - 2014-06-20 20:48 -0700
Re: Putting it all together Evan Platt <evan@theobvious.espphotography.com.invalid> - 2014-06-20 21:00 -0700
Re: Putting it all together Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-21 04:22 +0000
Re: Putting it all together Jürgen Exner <jurgenex@hotmail.com> - 2014-06-20 22:11 -0700
Re: Putting it all together Evan Platt <evan@theobvious.espphotography.com.invalid> - 2014-06-20 22:39 -0700
Re: Putting it all together gordonb.zp2md@burditt.org (Gordon Burditt) - 2014-06-21 04:15 -0500
Storing dates (was: Putting it all together) Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-21 12:15 +0200
Re: Storing dates Luuk <luuk@invalid.lan> - 2014-06-21 13:09 +0200
Re: Storing dates richard <noreply@example.com> - 2014-06-21 11:10 -0400
Re: Storing dates Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-21 17:42 +0000
Re: Storing dates richard <noreply@example.com> - 2014-06-21 14:28 -0400
Re: Storing dates Jürgen Exner <jurgenex@hotmail.com> - 2014-06-21 12:04 -0700
Re: Storing dates Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-21 19:06 +0000
Re: Storing dates Tim Streater <timstreater@greenbee.net> - 2014-06-21 22:06 +0100
Re: Storing dates Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-21 17:09 -0400
Re: Storing dates Tim Streater <timstreater@greenbee.net> - 2014-06-21 22:33 +0100
Re: Storing dates Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-21 17:49 -0400
Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-22 14:38 +0200
Re: Storing dates Jürgen Exner <jurgenex@hotmail.com> - 2014-06-21 14:31 -0700
Re: Storing dates Tim Streater <timstreater@greenbee.net> - 2014-06-21 22:44 +0100
Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-22 14:59 +0200
Re: Storing dates "Erick T. Barkhuis" <erick.use-net@ardane.c.o.m> - 2014-06-23 05:54 +0000
Re: Storing dates Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-21 23:19 +0000
Re: Storing dates Arno Welzel <usenet@arnowelzel.de> - 2014-06-22 08:53 +0200
Re: Storing dates "Erick T. Barkhuis" <erick.use-net@ardane.c.o.m> - 2014-06-22 08:03 +0000
Re: Storing dates Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-22 09:29 -0400
Re: Storing dates "Erick T. Barkhuis" <erick.use-net@ardane.c.o.m> - 2014-06-22 14:24 +0000
Re: Storing dates Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-22 10:32 -0400
Re: Storing dates "Erick T. Barkhuis" <erick.use-net@ardane.c.o.m> - 2014-06-22 14:45 +0000
Re: Storing dates Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-22 19:44 +0000
Re: Storing dates Jürgen Exner <jurgenex@hotmail.com> - 2014-06-22 08:26 -0700
Re: Storing dates gordonb.q26od@burditt.org (Gordon Burditt) - 2014-06-22 10:00 -0500
Re: Storing dates Arno Welzel <usenet@arnowelzel.de> - 2014-06-22 16:47 +0200
Re: Storing dates richard <noreply@example.com> - 2014-06-22 13:55 -0400
Re: Storing dates Jürgen Exner <jurgenex@hotmail.com> - 2014-06-22 12:31 -0700
Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-24 22:27 +0200
Re: Storing dates Jürgen Exner <jurgenex@hotmail.com> - 2014-06-24 13:41 -0700
Re: Storing dates Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-24 20:29 -0400
Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-25 08:17 +0200
Re: Storing dates "Erick T. Barkhuis" <erick.use-net@ardane.c.o.m> - 2014-06-25 06:31 +0000
Re: Storing dates Jürgen Exner <jurgenex@hotmail.com> - 2014-06-25 01:25 -0700
Re: Storing dates Doug Miller <doug_at_milmac_dot_com@example.com> - 2014-06-25 12:02 +0000
Re: Storing dates "Erick T. Barkhuis" <erick.use-net@ardane.c.o.m> - 2014-06-25 12:17 +0000
Re: Storing dates Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-22 19:52 +0000
Re: Storing dates Arno Welzel <usenet@arnowelzel.de> - 2014-06-22 21:52 +0200
Re: Storing dates richard <noreply@example.com> - 2014-06-22 14:05 -0400
Re: Storing dates Arno Welzel <usenet@arnowelzel.de> - 2014-06-22 21:56 +0200
Re: Storing dates richard <noreply@example.com> - 2014-06-22 22:46 -0400
Re: Storing dates Arno Welzel <usenet@arnowelzel.de> - 2014-06-23 08:11 +0200
Re: Storing dates richard <noreply@example.com> - 2014-06-23 02:37 -0400
Re: Storing dates Arno Welzel <usenet@arnowelzel.de> - 2014-06-23 11:10 +0200
Re: Storing dates Evan Platt <evan@theobvious.espphotography.com.invalid> - 2014-06-23 06:50 -0700
Re: Storing dates richard <noreply@example.com> - 2014-06-23 11:13 -0400
Re: Storing dates Evan Platt <evan@theobvious.espphotography.com.invalid> - 2014-06-23 09:13 -0700
Re: Storing dates Arno Welzel <usenet@arnowelzel.de> - 2014-06-23 22:33 +0200
Re: Storing dates richard <noreply@example.com> - 2014-06-22 23:04 -0400
Re: Storing dates Arno Welzel <usenet@arnowelzel.de> - 2014-06-23 08:12 +0200
Re: Storing dates Geoff Muldoon <geoff.muldoon@trap.gmail.com> - 2014-06-23 16:45 +1000
Re: Storing dates richard <noreply@example.com> - 2014-06-23 07:58 -0400
Re: Storing dates Jürgen Exner <jurgenex@hotmail.com> - 2014-06-23 09:50 -0700
Re: Storing dates Christoph Michael Becker <cmbecker69@arcor.de> - 2014-06-23 19:02 +0200
Re: Storing dates Geoff Muldoon <geoff.muldoon@trap.gmail.com> - 2014-06-24 12:00 +1000
Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-24 22:38 +0200
Re: Storing dates Geoff Muldoon <geoff.muldoon@trap.gmail.com> - 2014-06-25 09:03 +1000
Re: Storing dates Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-24 20:27 -0400
Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-25 17:15 +0200
Re: Storing dates Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-25 11:43 -0400
Re: Storing dates Geoff Muldoon <geoff.muldoon@trap.gmail.com> - 2014-06-25 11:34 +1000
Re: Storing dates Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-25 08:20 +0200
Re: Storing dates Jürgen Exner <jurgenex@hotmail.com> - 2014-06-22 15:30 -0700
Re: Storing dates "Peter H. Coffin" <hellsop@ninehells.com> - 2014-06-22 20:10 -0500
Re: Putting it all together Jürgen Exner <jurgenex@hotmail.com> - 2014-06-21 03:34 -0700
Re: Putting it all together "Erick T. Barkhuis" <erick.use-net@ardane.c.o.m> - 2014-06-21 12:27 +0000
Re: Putting it all together Jürgen Exner <jurgenex@hotmail.com> - 2014-06-21 08:25 -0700
Re: Putting it all together Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-21 10:23 +0000
Re: Putting it all together bill <william@TechServSys.com> - 2014-06-21 07:03 -0400
Re: Putting it all together Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-21 15:11 +0000
Re: Putting it all together "Peter H. Coffin" <hellsop@ninehells.com> - 2014-06-21 10:57 -0500
Re: Putting it all together Arno Welzel <usenet@arnowelzel.de> - 2014-06-22 08:45 +0200
Page 4 of 5 — ← Prev page 1 2 3 [4] 5 Next page →
| From | richard <noreply@example.com> |
|---|---|
| Date | 2014-06-23 02:37 -0400 |
| Subject | Re: Storing dates |
| Message-ID | <x92zxpmduu72$.1vls2a10yowdx$.dlg@40tude.net> |
| In reply to | #5424 |
On Mon, 23 Jun 2014 08:11:46 +0200, Arno Welzel wrote: > richard, 2014-06-23 04:46: > >> On Sun, 22 Jun 2014 21:56:57 +0200, Arno Welzel wrote: >> >>> richard, 2014-06-22 20:05: >>> >>>> On Sun, 22 Jun 2014 08:53:17 +0200, Arno Welzel wrote: >>>> >>> [about date storage in databases] >>>>> BTW: This is why ISO 8601 had been invented - see >>>>> <http://en.wikipedia.org/wiki/ISO_8601>. >>>> >>>> Doesn't matter anymore. I am using the numeric day system instead. >>>> where $date=date(z). >>> >>> Really? Literally "where $date=date(z)"? Looks very unusual. >>> >>> And even if this would make any sense - it least in MySQL date() is >>> *not* a "numeric day system": >>> >>> <http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date> > > This does still not explain, why you use "where $date=date(z)". PHP > itself does not execute SQL statements. Look dunbshit, I am not using "where" here as an sql statement or property. for instance you see something like mm-dd-yy then the writer says, "Where m=month, d=day, and y=year". "Where" is used routinely to define what the writer meant by his abbreviations and such. No Mr. Miller, I am not apologizing to him or you. He's just being an irritating troll now.
[toc] | [prev] | [next] | [standalone]
| From | Arno Welzel <usenet@arnowelzel.de> |
|---|---|
| Date | 2014-06-23 11:10 +0200 |
| Subject | Re: Storing dates |
| Message-ID | <53A7EEFF.8060103@arnowelzel.de> |
| In reply to | #5426 |
Am 2014-06-23 08:37, schrieb richard: > Look dunbshit, [...] Ok, welcome to my filter. My apologies that I did not ignore you earlier. -- Arno Welzel http://arnowelzel.de http://de-rec-fahrrad.de http://fahrradzukunft.de
[toc] | [prev] | [next] | [standalone]
| From | Evan Platt <evan@theobvious.espphotography.com.invalid> |
|---|---|
| Date | 2014-06-23 06:50 -0700 |
| Subject | Re: Storing dates |
| Message-ID | <14cgq9d6g6jo3sduqr455m40o2mc1b5j85@4ax.com> |
| In reply to | #5426 |
On Mon, 23 Jun 2014 02:37:14 -0400, richard <noreply@example.com> wrote: >Look dunbshit, I am not using "where" here as an sql statement or property. Wow, I hope Lew reconsiders his offer to help bullis now. bullis, you better learn SQL and PHP REAL quick, because you're alienating the entire group here. -- To reply via e-mail, remove The Obvious and .invalid from my e-mail address.
[toc] | [prev] | [next] | [standalone]
| From | richard <noreply@example.com> |
|---|---|
| Date | 2014-06-23 11:13 -0400 |
| Subject | Re: Storing dates |
| Message-ID | <1rq88fv5jlwlt.688lboqaznlc.dlg@40tude.net> |
| In reply to | #5431 |
On Mon, 23 Jun 2014 06:50:43 -0700, Evan Platt wrote: > On Mon, 23 Jun 2014 02:37:14 -0400, richard <noreply@example.com> > wrote: > >>Look dunbshit, I am not using "where" here as an sql statement or property. > > Wow, I hope Lew reconsiders his offer to help bullis now. > > bullis, you better learn SQL and PHP REAL quick, because you're > alienating the entire group here. You certainly have helped on that. Just because SQL or other lamguages use a common every day word in its structure does not mean that is the only way that word can be used. Arno took the context and wrongfully assumed that I was referring to the use of "where" in the select statement.This is not what I was using the word for. And all you do is add agitation to it all purely for wanting to make things worse than they are.
[toc] | [prev] | [next] | [standalone]
| From | Evan Platt <evan@theobvious.espphotography.com.invalid> |
|---|---|
| Date | 2014-06-23 09:13 -0700 |
| Subject | Re: Storing dates |
| Message-ID | <2bkgq9l29jck9mvb6jl9hpfqrsh8gcmb62@4ax.com> |
| In reply to | #5432 |
On Mon, 23 Jun 2014 11:13:23 -0400, richard <noreply@example.com> wrote: >> bullis, you better learn SQL and PHP REAL quick, because you're >> alienating the entire group here. > >You certainly have helped on that. Take responsibility for your actions, bullis. You calling the regulars here dumbshits, creating sock puppets when people refuse to help you, and insulting everyone here means you are 100% responsible for alienating people here. >Just because SQL or other lamguages use a common every day word in its >structure does not mean that is the only way that word can be used. >Arno took the context and wrongfully assumed that I was referring to the >use of "where" in the select statement.This is not what I was using the >word for. Oh. I misunderstood. In that case, you were fully justified in calling Arno a dumbshit. </sarcasm> >And all you do is add agitation to it all purely for wanting to make things >worse than they are. See my first paragraph. You can only blame yourself. -- To reply via e-mail, remove The Obvious and .invalid from my e-mail address.
[toc] | [prev] | [next] | [standalone]
| From | Arno Welzel <usenet@arnowelzel.de> |
|---|---|
| Date | 2014-06-23 22:33 +0200 |
| Subject | Re: Storing dates |
| Message-ID | <53A88F23.3010309@arnowelzel.de> |
| In reply to | #5433 |
Evan Platt, 2014-06-23 18:13: > On Mon, 23 Jun 2014 11:13:23 -0400, richard <noreply@example.com> > wrote: > >>> bullis, you better learn SQL and PHP REAL quick, because you're >>> alienating the entire group here. >> >> You certainly have helped on that. > > Take responsibility for your actions, bullis. You calling the regulars > here dumbshits, creating sock puppets when people refuse to help you, > and insulting everyone here means you are 100% responsible for > alienating people here. The best way to deal with such people is to ignore them and not to produce more off-topic noise. Thank you! -- Arno Welzel http://arnowelzel.de http://de-rec-fahrrad.de http://fahrradzukunft.de
[toc] | [prev] | [next] | [standalone]
| From | richard <noreply@example.com> |
|---|---|
| Date | 2014-06-22 23:04 -0400 |
| Subject | Re: Storing dates |
| Message-ID | <799zxuonxakb$.10x90vriz3wvb$.dlg@40tude.net> |
| In reply to | #5414 |
On Sun, 22 Jun 2014 21:56:57 +0200, Arno Welzel wrote: > richard, 2014-06-22 20:05: > >> On Sun, 22 Jun 2014 08:53:17 +0200, Arno Welzel wrote: >> > [about date storage in databases] >>> BTW: This is why ISO 8601 had been invented - see >>> <http://en.wikipedia.org/wiki/ISO_8601>. >> >> Doesn't matter anymore. I am using the numeric day system instead. >> where $date=date(z). > > Really? Literally "where $date=date(z)"? Looks very unusual. > > And even if this would make any sense - it least in MySQL date() is > *not* a "numeric day system": > > <http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date> > > Or did you switch to another database system? BTW, date() itself is not anything but a function. date(z) takes the current date of the server and trasnform it into a number in the range of 1 to 366. If the date were 2014-01-01, date(z) would return 1. Dayofyear() takes that number and transform it back to the calendar date. In my use of "where", I meant that as "an example", not as used by mysql select from where stuff.
[toc] | [prev] | [next] | [standalone]
| From | Arno Welzel <usenet@arnowelzel.de> |
|---|---|
| Date | 2014-06-23 08:12 +0200 |
| Subject | Re: Storing dates |
| Message-ID | <53A7C563.6050901@arnowelzel.de> |
| In reply to | #5422 |
richard, 2014-06-23 05:04: [...] > BTW, date() itself is not anything but a function. > date(z) takes the current date of the server and trasnform it into a number > in the range of 1 to 366. > > If the date were 2014-01-01, date(z) would return 1. > Dayofyear() takes that number and transform it back to the calendar date. Yep - but only for the current year. Next year 1 would meen 2015-01-01 and so on. -- Arno Welzel http://arnowelzel.de http://de-rec-fahrrad.de http://fahrradzukunft.de
[toc] | [prev] | [next] | [standalone]
| From | Geoff Muldoon <geoff.muldoon@trap.gmail.com> |
|---|---|
| Date | 2014-06-23 16:45 +1000 |
| Subject | Re: Storing dates |
| Message-ID | <MPG.2e127810e15b0738cf@news.albasani.net> |
| In reply to | #5425 |
In article <53A7C563.6050901@arnowelzel.de>, usenet@arnowelzel.de says... > > richard, 2014-06-23 05:04: > > [...] > > BTW, date() itself is not anything but a function. > > date(z) takes the current date of the server and trasnform it into a number > > in the range of 1 to 366. > > > > If the date were 2014-01-01, date(z) would return 1. > > Dayofyear() takes that number and transform it back to the calendar date. > > Yep - but only for the current year. Next year 1 would meen 2015-01-01 > and so on. Doesn't the MySQL DATEOFYEAR() function actually take a DATE data type input and return a number (in range 1-366)? Unless of course Richard is talking about some weird non-mysql PHP function he has cobbled together. GM
[toc] | [prev] | [next] | [standalone]
| From | richard <noreply@example.com> |
|---|---|
| Date | 2014-06-23 07:58 -0400 |
| Subject | Re: Storing dates |
| Message-ID | <x8ho1i1kpop.1lbnaaunxn171$.dlg@40tude.net> |
| In reply to | #5427 |
On Mon, 23 Jun 2014 16:45:23 +1000, Geoff Muldoon wrote: > In article <53A7C563.6050901@arnowelzel.de>, usenet@arnowelzel.de > says... >> >> richard, 2014-06-23 05:04: >> >> [...] >>> BTW, date() itself is not anything but a function. >>> date(z) takes the current date of the server and trasnform it into a number >>> in the range of 1 to 366. >>> >>> If the date were 2014-01-01, date(z) would return 1. >>> Dayofyear() takes that number and transform it back to the calendar date. >> >> Yep - but only for the current year. Next year 1 would meen 2015-01-01 >> and so on. > > Doesn't the MySQL DATEOFYEAR() function actually take a DATE data type > input and return a number (in range 1-366)? > > Unless of course Richard is talking about some weird non-mysql PHP > function he has cobbled together. > > GM As I get told so frequently, RTFM asshole!
[toc] | [prev] | [next] | [standalone]
| From | Jürgen Exner <jurgenex@hotmail.com> |
|---|---|
| Date | 2014-06-23 09:50 -0700 |
| Subject | Re: Storing dates |
| Message-ID | <mfmgq95el8ea0bcpirjnr5t46rppuheora@4ax.com> |
| In reply to | #5430 |
On Mon, 23 Jun 2014 07:58:20 -0400, richard <noreply@example.com> wrote in comp.databases.mysql: >>> richard, 2014-06-23 05:04: >>>> BTW, date() itself is not anything but a function. >>>> date(z) takes the current date of the server and trasnform it into a number >>>> in the range of 1 to 366. >>>> Dayofyear() takes that number and transform it back to the calendar date. > >As I get told so frequently, RTFM asshole! I tried. But unfortunately I couldn't find said functions with said functionality at http://dev.mysql.com/doc/refman/5.7/en/language-structure.html jue
[toc] | [prev] | [next] | [standalone]
| From | Christoph Michael Becker <cmbecker69@arcor.de> |
|---|---|
| Date | 2014-06-23 19:02 +0200 |
| Subject | Re: Storing dates |
| Message-ID | <53a85d9c$0$6669$9b4e6d93@newsspool3.arcor-online.net> |
| In reply to | #5434 |
Jürgen Exner wrote:
> On Mon, 23 Jun 2014 07:58:20 -0400, richard <noreply@example.com> wrote
> in comp.databases.mysql:
>>>> richard, 2014-06-23 05:04:
>>>>> BTW, date() itself is not anything but a function.
>>>>> date(z) takes the current date of the server and trasnform it into a number
>>>>> in the range of 1 to 366.
>>>>> Dayofyear() takes that number and transform it back to the calendar date.
>>
>> As I get told so frequently, RTFM asshole!
>
> I tried. But unfortunately I couldn't find said functions with said
> functionality at
> http://dev.mysql.com/doc/refman/5.7/en/language-structure.html
richard is referring to PHP's date[1] function. This should correctly
be called with a string argument (not a constant, as written above), e.g.
date('z')
And, of course, PHP stuff shouldn't be discussed in
comp.databases.mysql, so xpost & fup2 comp.lang.php.
[1] <http://www.php.net/manual/en/function.date.php>
--
Christoph M. Becker
[toc] | [prev] | [next] | [standalone]
| From | Geoff Muldoon <geoff.muldoon@trap.gmail.com> |
|---|---|
| Date | 2014-06-24 12:00 +1000 |
| Subject | Re: Storing dates |
| Message-ID | <MPG.2e1386bd494abe6ad0@news.albasani.net> |
| In reply to | #5430 |
Richard noreply@example.com says... > >>> If the date were 2014-01-01, date(z) would return 1. > >>> Dayofyear() takes that number and transform it back to the calendar date. > > Doesn't the MySQL DATEOFYEAR() function actually take a DATE data type > > input and return a number (in range 1-366)? > As I get told so frequently, RTFM asshole! Do you mean this? http://dev.mysql.com/doc/refman/5.5/en/date-and-time- functions.html#function_dayofyear I can't find any in-built PHP function of that name, please post a link to said manual entry. Arsehole. GM
[toc] | [prev] | [next] | [standalone]
| From | Thomas 'PointedEars' Lahn <PointedEars@web.de> |
|---|---|
| Date | 2014-06-24 22:38 +0200 |
| Subject | Re: Storing dates |
| Message-ID | <4486398.v5FkVC2umb@PointedEars.de> |
| In reply to | #5427 |
Geoff Muldoon <geoff.muldoon@trap.gmail.com> wrote:
^^^^^^^^^^^^^^
The “From” header field value must contain a proper e-mail address. I do
not think Google will take kindly on your misusing their namespace. Such
header field values are also expressly forbidden at albasani.net.
<http://www.interhack.net/pubs/munging-harmful/>
<http://albasani.net/info/terms_of_use.html.en>
> In article <53A7C563.6050901@arnowelzel.de>, usenet@arnowelzel.de
> says...
It’s attribution *line*, _not_ attribution novel.
>> richard, 2014-06-23 05:04:
>> [...]
>> > BTW, date() itself is not anything but a function.
>> > date(z) takes the current date of the server and trasnform it into a
>> > number in the range of 1 to 366.
>> >
>> > If the date were 2014-01-01, date(z) would return 1.
>> > Dayofyear() takes that number and transform it back to the calendar
>> > date.
>>
>> Yep - but only for the current year. Next year 1 would meen 2015-01-01
>> and so on.
>
> Doesn't the MySQL DATEOFYEAR() function actually take a DATE data type
> input and return a number (in range 1-366)?
Yes, it does not; there is no such MySQL function. Probably you mean
<http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_dayofyear>
PointedEars
--
Use any version of Microsoft Frontpage to create your site.
(This won't prevent people from viewing your source, but no one
will want to steal it.)
-- from <http://www.vortex-webdesign.com/help/hidesource.htm> (404-comp.)
[toc] | [prev] | [next] | [standalone]
| From | Geoff Muldoon <geoff.muldoon@trap.gmail.com> |
|---|---|
| Date | 2014-06-25 09:03 +1000 |
| Subject | Re: Storing dates |
| Message-ID | <MPG.2e14aed71bc48a78d3@news.albasani.net> |
| In reply to | #5459 |
PointedEars@web.de says... > > Geoff Muldoon <geoff.muldoon@trap.gmail.com> wrote: > > Doesn't the MySQL DATEOFYEAR() function actually take a DATE data type > > input and return a number (in range 1-366)? > > Yes, it does not; there is no such MySQL function. Probably you mean > > <http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_dayofyear> Oops, excuse my tpyo.\ GM
[toc] | [prev] | [next] | [standalone]
| From | Jerry Stuckle <jstucklex@attglobal.net> |
|---|---|
| Date | 2014-06-24 20:27 -0400 |
| Subject | Re: Storing dates |
| Message-ID | <lod50j$ufl$1@dont-email.me> |
| In reply to | #5459 |
On 6/24/2014 4:38 PM, The pedantic 'Pointed Head' Lahn wrote: > Geoff Muldoon <geoff.muldoon@trap.gmail.com> wrote: > ^^^^^^^^^^^^^^ > The “From” header field value must contain a proper e-mail address. I do > not think Google will take kindly on your misusing their namespace. Such > header field values are also expressly forbidden at albasani.net. > So what? It's not your problem. Get over it! No one else here gives a damn. -- ================== Remove the "x" from my email address Jerry Stuckle jstucklex@attglobal.net ==================
[toc] | [prev] | [next] | [standalone]
| From | Thomas 'PointedEars' Lahn <PointedEars@web.de> |
|---|---|
| Date | 2014-06-25 17:15 +0200 |
| Subject | Re: Storing dates |
| Message-ID | <1919637.1kb8JKirvo@PointedEars.de> |
| In reply to | #5462 |
Jerry Stuckle wrote: > On 6/24/2014 4:38 PM, The pedantic 'Pointed Head' Lahn wrote: >> Geoff Muldoon <geoff.muldoon@trap.gmail.com> wrote: >> ^^^^^^^^^^^^^^ >> The “From” header field value must contain a proper e-mail address. I do >> not think Google will take kindly on your misusing their namespace. Such >> header field values are also expressly forbidden at albasani.net. > > So what? It's not your problem. […] The standard (RFC 5536, referring to RFC 5322) specifies it so also because not being able to contact the author of a message privately *is* a problem in a public communications medium. It is anti-social to block that important channel in advance, causing off- topic discussions. It is anti-social to help spammers to destroy e-mail as a viable communications medium. It is anti-social to burden others (other netizens who would want to reply via e-mail, administrators which would either have to deal with bounces or to receive those messages, or limit the SLD owner’s ability to use subdomains in the space that they paid for) by the results of one’s inability to deal with spam properly. Those problems caused by ignorance should concern every netizen, and they certainly concern not only me. -- PointedEars Twitter: @PointedEars2 Please do not Cc: me. / Bitte keine Kopien per E-Mail.
[toc] | [prev] | [next] | [standalone]
| From | Jerry Stuckle <jstucklex@attglobal.net> |
|---|---|
| Date | 2014-06-25 11:43 -0400 |
| Subject | Re: Storing dates |
| Message-ID | <loeqmq$8rp$1@dont-email.me> |
| In reply to | #5487 |
On 6/25/2014 11:15 AM, Thomas 'PointedEars' Lahn wrote: > Jerry Stuckle wrote: > >> On 6/24/2014 4:38 PM, The pedantic 'Pointed Head' Lahn wrote: >>> Geoff Muldoon <geoff.muldoon@trap.gmail.com> wrote: >>> ^^^^^^^^^^^^^^ >>> The “From” header field value must contain a proper e-mail address. I do >>> not think Google will take kindly on your misusing their namespace. Such >>> header field values are also expressly forbidden at albasani.net. >> >> So what? It's not your problem. […] > > The standard (RFC 5536, referring to RFC 5322) specifies it so also because > not being able to contact the author of a message privately *is* a problem > in a public communications medium. > > It is anti-social to block that important channel in advance, causing off- > topic discussions. It is anti-social to help spammers to destroy e-mail as > a viable communications medium. It is anti-social to burden others (other > netizens who would want to reply via e-mail, administrators which would > either have to deal with bounces or to receive those messages, or limit the > SLD owner’s ability to use subdomains in the space that they paid for) by > the results of one’s inability to deal with spam properly. > > Those problems caused by ignorance should concern every netizen, and they > certainly concern not only me. > And you're the only netcop in this (and every other newsgroup I read) who gives a damn about any of this. But we all know how pedantic you are. -- ================== Remove the "x" from my email address Jerry Stuckle jstucklex@attglobal.net ==================
[toc] | [prev] | [next] | [standalone]
| From | Geoff Muldoon <geoff.muldoon@trap.gmail.com> |
|---|---|
| Date | 2014-06-25 11:34 +1000 |
| Subject | Re: Storing dates |
| Message-ID | <MPG.2e14d236525d5cbbd4@news.albasani.net> |
| In reply to | #5459 |
PointedEars@web.de says... > > Geoff Muldoon <geoff.muldoon@trap.gmail.com> wrote: > ^^^^^^^^^^^^^^ > The ?From? header field value must contain a proper e-mail address. I do > not think Google will take kindly on your misusing their namespace. Such > header field values are also expressly forbidden at albasani.net. Frankly I don't really give a rat's arse what Google thinks, but in order to respect the wishes of the good people at albasani I will change it to invalid.invalid shortly. GM
[toc] | [prev] | [next] | [standalone]
| From | Thomas 'PointedEars' Lahn <PointedEars@web.de> |
|---|---|
| Date | 2014-06-25 08:20 +0200 |
| Subject | Re: Storing dates |
| Message-ID | <16942164.UWOLcbVYFK@PointedEars.de> |
| In reply to | #5464 |
Geoff Muldoon wrote:
> PointedEars@web.de says...
>> Geoff Muldoon <geoff.muldoon@trap.gmail.com> wrote:
>> ^^^^^^^^^^^^^^
>> The ?From? header field value must contain a proper e-mail address. I do
>> not think Google will take kindly on your misusing their namespace. Such
>> header field values are also expressly forbidden at albasani.net.
>
> Frankly I don't really give a rat's arse what Google thinks, but in
> order to respect the wishes of the good people at albasani I will change
> it to invalid.invalid shortly.
^^^^^^^^^^^^^^^
Good; our killfiles await you.
<http://www.interhack.net/pubs/munging-harmful/>
F'up2 poster
--
PointedEars
Twitter: @PointedEars2
Please do not Cc: me. / Bitte keine Kopien per E-Mail.
[toc] | [prev] | [next] | [standalone]
Page 4 of 5 — ← Prev page 1 2 3 [4] 5 Next page →
Back to top | Article view | comp.databases.mysql
csiph-web