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 #186245 is a reply to message #186244]

Sat, 21 June 2014 19:04

Jrgen Exner
Messages: 14
Registered: March 2013

Karma:

Junior Member

On Sat, 21 Jun 2014 14:28:47 -0400, richard <noreply(at)example(dot)com> wrote
in comp.databases.mysql:

> 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

A normal ascending numerical sort

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

A normal ascending alphabetical sort

> Or maybe even as
> 100
> 10
> 1
> 2

This looks rather strange. Even if there were a trailing space character
then still "10 " would be sorted before "100 ". What sorting is this?

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

Again, a standard alphabetical sort.

So, which sorting order do you want? Numerical or alphabetical? And is
your data stored as number or as string? And if the type doesn't match
then what happened when you cast it into the right data type?

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: Mon Nov 25 00:04:33 GMT 2024

Total time taken to generate the page: 0.04583 seconds