FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Putting it all together
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Storing dates [message #186296 is a reply to message #186293] Mon, 23 June 2014 06:45 Go to previous messageGo to previous message
Geoff Muldoon is currently offline  Geoff Muldoon
Messages: 19
Registered: July 2011
Karma:
Junior Member
In article <53A7C563(dot)6050901(at)arnowelzel(dot)de>, usenet(at)arnowelzel(dot)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
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: str_replace does not like empty quotes
Next Topic: SplFileObject always returns an extra "last" line -- why?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 13:20:37 GMT 2024

Total time taken to generate the page: 0.05480 seconds