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: Storing dates [message #186244 is a reply to message #186241]

Sat, 21 June 2014 18:28

Mr Oldies
Messages: 241
Registered: October 2013

Karma:

Senior Member

On Sat, 21 Jun 2014 17:42:29 +0000 (UTC), Doug Miller wrote:

> richard <noreply(at)example(dot)com> wrote in news:1mddkhwt2mr0v$.1m6eithcu7iod.dlg@
> 40tude.net:
>
>> As for the date usage on MY database tables, I am only using a date as a
>> reference.
>
> Patently false, as you have posted questions here asking for help resolving your problems in
> sorting by the date.
>
>> I really don't give a damn what your philosophy or ideals are
>> behind the so called "proper ways" of obtaining a date.
>
> Which is exactly *why* you have problems sorting by the date.

The problem with sorting is, it treats any value given as a string, then
determines which has the lowest value in total.
1
2
3
10
20
30
100
200
300

When you sort these numbers, how do they get displayed?
You will most likely see them displayed as:
1
10
100
2
Or maybe even as
100
10
1
2

In Liberty BASIC I got (as strings)
1
10
100
2
20
200
3
30
300

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 21:30:55 GMT 2024

Total time taken to generate the page: 0.04856 seconds