Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.mysql > #5358 > unrolled thread

Putting it all together

Started byrichard <noreply@example.com>
First post2014-06-20 10:20 -0400
Last post2014-06-22 08:45 +0200
Articles 20 on this page of 90 — 18 participants

Back to article view | Back to comp.databases.mysql


Contents

  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 →


#5426 — Re: Storing dates

Fromrichard <noreply@example.com>
Date2014-06-23 02:37 -0400
SubjectRe: 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]


#5429 — Re: Storing dates

FromArno Welzel <usenet@arnowelzel.de>
Date2014-06-23 11:10 +0200
SubjectRe: 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]


#5431 — Re: Storing dates

FromEvan Platt <evan@theobvious.espphotography.com.invalid>
Date2014-06-23 06:50 -0700
SubjectRe: 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]


#5432 — Re: Storing dates

Fromrichard <noreply@example.com>
Date2014-06-23 11:13 -0400
SubjectRe: 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]


#5433 — Re: Storing dates

FromEvan Platt <evan@theobvious.espphotography.com.invalid>
Date2014-06-23 09:13 -0700
SubjectRe: 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]


#5443 — Re: Storing dates

FromArno Welzel <usenet@arnowelzel.de>
Date2014-06-23 22:33 +0200
SubjectRe: 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]


#5422 — Re: Storing dates

Fromrichard <noreply@example.com>
Date2014-06-22 23:04 -0400
SubjectRe: 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]


#5425 — Re: Storing dates

FromArno Welzel <usenet@arnowelzel.de>
Date2014-06-23 08:12 +0200
SubjectRe: 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]


#5427 — Re: Storing dates

FromGeoff Muldoon <geoff.muldoon@trap.gmail.com>
Date2014-06-23 16:45 +1000
SubjectRe: 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]


#5430 — Re: Storing dates

Fromrichard <noreply@example.com>
Date2014-06-23 07:58 -0400
SubjectRe: 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]


#5434 — Re: Storing dates

FromJürgen Exner <jurgenex@hotmail.com>
Date2014-06-23 09:50 -0700
SubjectRe: 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]


#5435 — Re: Storing dates

FromChristoph Michael Becker <cmbecker69@arcor.de>
Date2014-06-23 19:02 +0200
SubjectRe: 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]


#5450 — Re: Storing dates

FromGeoff Muldoon <geoff.muldoon@trap.gmail.com>
Date2014-06-24 12:00 +1000
SubjectRe: 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]


#5459 — Re: Storing dates

FromThomas 'PointedEars' Lahn <PointedEars@web.de>
Date2014-06-24 22:38 +0200
SubjectRe: 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]


#5461 — Re: Storing dates

FromGeoff Muldoon <geoff.muldoon@trap.gmail.com>
Date2014-06-25 09:03 +1000
SubjectRe: 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]


#5462 — Re: Storing dates

FromJerry Stuckle <jstucklex@attglobal.net>
Date2014-06-24 20:27 -0400
SubjectRe: 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]


#5487 — Re: Storing dates

FromThomas 'PointedEars' Lahn <PointedEars@web.de>
Date2014-06-25 17:15 +0200
SubjectRe: 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]


#5488 — Re: Storing dates

FromJerry Stuckle <jstucklex@attglobal.net>
Date2014-06-25 11:43 -0400
SubjectRe: 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]


#5464 — Re: Storing dates

FromGeoff Muldoon <geoff.muldoon@trap.gmail.com>
Date2014-06-25 11:34 +1000
SubjectRe: 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]


#5466 — Re: Storing dates

FromThomas 'PointedEars' Lahn <PointedEars@web.de>
Date2014-06-25 08:20 +0200
SubjectRe: 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