FUDforum: comp.lang.php » Putting it all together

Home » Imported messages » comp.lang.php » Putting it all together

Show: Today's Messages :: Polls :: Message Navigator

Re: Putting it all together [message #186223 is a reply to message #186222]

Sat, 21 June 2014 03:48

Jrgen Exner
Messages: 14
Registered: March 2013

Karma:

Junior Member

On Fri, 20 Jun 2014 23:34:19 -0400, richard <noreply(at)example(dot)com> wrote
in comp.databases.mysql:

> On Fri, 20 Jun 2014 20:13:10 -0700, Jürgen Exner wrote:
>
>> On Fri, 20 Jun 2014 10:20:59 -0400, richard <noreply(at)example(dot)com> wrote
>> in comp.databases.mysql:
>>
>>> For this excercise, I decided to order by artist.
>>> I'll do it by date later.
>>
>> That should be as simple as
>> SELECT .... FROM ...... ORDER BY date
>>
>> Of course that assumes that date is of type date (or datetime) as any
>> sane person would store a date.
>
> what if use Julian dates?
> that throws all of your damn bullshit right down the drain don't it?

If done correctly it is still as simple as
SELECT .... FROM ...... ORDER BY date
Of course you have the additional trouble of converting back and forth
between Julian and Gregorian date and time because there aren't many
people who could interpret a Julian date, but that can certainly be
solved.

jue

Report message to a moderator

[Message index]

		Putting it all together By: Mr Oldies on Fri, 20 June 2014 14:20
		Re: Putting it all together By: Evan Platt on Fri, 20 June 2014 15:11
		Re: Putting it all together By: Mr Oldies on Fri, 20 June 2014 15:24
		Re: Putting it all together By: Doug Miller on Fri, 20 June 2014 17:15
		Re: Putting it all together By: Evan Platt on Sat, 21 June 2014 03:01
		Re: Putting it all together By: Jrgen Exner on Fri, 20 June 2014 15:21
		Re: Putting it all together By: Norman Peelman on Sat, 21 June 2014 01:06
		Re: Putting it all together By: Denis McMahon on Sat, 21 June 2014 03:02
		Re: Putting it all together By: Denis McMahon on Sat, 21 June 2014 03:09
		Re: Putting it all together By: Jrgen Exner on Sat, 21 June 2014 03:13
		Re: Putting it all together By: Mr Oldies on Sat, 21 June 2014 03:34
		Re: Putting it all together By: Jrgen Exner on Sat, 21 June 2014 03:48
		Re: Putting it all together By: Evan Platt on Sat, 21 June 2014 04:00
		Re: Putting it all together By: Doug Miller on Sat, 21 June 2014 04:22
		Re: Putting it all together By: Jrgen Exner on Sat, 21 June 2014 05:11
		Re: Putting it all together By: Evan Platt on Sat, 21 June 2014 05:39
		Re: Putting it all together By: gordonb.zp2md on Sat, 21 June 2014 09:15
		Storing dates (was: Putting it all together) By: Thomas 'PointedEars' on Sat, 21 June 2014 10:15
		Re: Storing dates By: Mr Oldies on Sat, 21 June 2014 15:10
		Re: Storing dates By: Doug Miller on Sat, 21 June 2014 17:42
		Re: Storing dates By: Mr Oldies on Sat, 21 June 2014 18:28
		Re: Storing dates By: Jrgen Exner on Sat, 21 June 2014 19:04
		Re: Storing dates By: Doug Miller on Sat, 21 June 2014 19:06
		Re: Storing dates By: Tim Streater on Sat, 21 June 2014 21:06
		Re: Storing dates By: Jerry Stuckle on Sat, 21 June 2014 21:09
		Re: Storing dates By: Tim Streater on Sat, 21 June 2014 21:33
		Re: Storing dates By: Jerry Stuckle on Sat, 21 June 2014 21:49
		Re: Storing dates By: Thomas 'PointedEars' on Sun, 22 June 2014 12:38
		Re: Storing dates By: Jrgen Exner on Sat, 21 June 2014 21:31
		Re: Storing dates By: Tim Streater on Sat, 21 June 2014 21:44
		Re: Storing dates By: Thomas 'PointedEars' on Sun, 22 June 2014 12:59
		Re: Storing dates By: Denis McMahon on Sat, 21 June 2014 23:19
		Re: Storing dates By: Arno Welzel on Sun, 22 June 2014 06:53
		Re: Storing dates By: Erick T. Barkhuis on Sun, 22 June 2014 08:03
		Re: Storing dates By: Jerry Stuckle on Sun, 22 June 2014 13:29
		Re: Storing dates By: Erick T. Barkhuis on Sun, 22 June 2014 14:24
		Re: Storing dates By: Jerry Stuckle on Sun, 22 June 2014 14:32
		Re: Storing dates By: Erick T. Barkhuis on Sun, 22 June 2014 14:45
		Re: Storing dates By: Denis McMahon on Sun, 22 June 2014 19:44
		Re: Storing dates By: Jrgen Exner on Sun, 22 June 2014 15:26
		Re: Storing dates By: gordonb.q26od on Sun, 22 June 2014 15:00
		Re: Storing dates By: Arno Welzel on Sun, 22 June 2014 14:47
		Re: Storing dates By: Mr Oldies on Sun, 22 June 2014 17:55
		Re: Storing dates By: Jrgen Exner on Sun, 22 June 2014 19:31
		Re: Storing dates By: Thomas 'PointedEars' on Tue, 24 June 2014 20:27
		Re: Storing dates By: Denis McMahon on Sun, 22 June 2014 19:52
		Re: Storing dates By: Arno Welzel on Sun, 22 June 2014 19:52
		Re: Storing dates By: Mr Oldies on Sun, 22 June 2014 18:05
		Re: Storing dates By: Arno Welzel on Sun, 22 June 2014 19:56
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 02:46
		Re: Storing dates By: Arno Welzel on Mon, 23 June 2014 06:11
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 06:37
		Re: Storing dates By: Arno Welzel on Mon, 23 June 2014 09:10
		Re: Storing dates By: Evan Platt on Mon, 23 June 2014 13:50
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 15:13
		Re: Storing dates By: Evan Platt on Mon, 23 June 2014 16:13
		Re: Storing dates By: Arno Welzel on Mon, 23 June 2014 20:33
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 03:04
		Re: Storing dates By: Arno Welzel on Mon, 23 June 2014 06:12
		Re: Storing dates By: Geoff Muldoon on Mon, 23 June 2014 06:45
		Re: Storing dates By: Mr Oldies on Mon, 23 June 2014 11:58
		Re: Storing dates By: Jrgen Exner on Mon, 23 June 2014 16:50
		Re: Storing dates By: Christoph Michael Bec on Mon, 23 June 2014 17:02
		Re: Storing dates By: Geoff Muldoon on Tue, 24 June 2014 02:00
		Re: Storing dates By: Thomas 'PointedEars' on Tue, 24 June 2014 20:38
		Re: Storing dates By: Jrgen Exner on Sun, 22 June 2014 22:30
		Re: Storing dates By: Peter H. Coffin on Mon, 23 June 2014 01:10
		Re: Putting it all together By: Jrgen Exner on Sat, 21 June 2014 10:34
		Re: Putting it all together By: Denis McMahon on Sat, 21 June 2014 10:23
		Re: Putting it all together By: bill on Sat, 21 June 2014 11:03
		Re: Putting it all together By: Denis McMahon on Sat, 21 June 2014 15:11
		Re: Putting it all together By: Peter H. Coffin on Sat, 21 June 2014 15:57
		Re: Putting it all together By: Arno Welzel on Sun, 22 June 2014 06:45

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) ] [

]

Current Time: Thu Nov 21 22:19:19 GMT 2024

Total time taken to generate the page: 0.05601 seconds