Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #13946
| From | Doug Miller <doug_at_milmac_dot_com@example.com> |
|---|---|
| Newsgroups | comp.lang.php, comp.databases.mysql |
| Subject | Re: Putting it all together |
| Date | 2014-06-21 04:22 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <XnsA3533BF035EAdougmilmaccom@78.46.70.116> (permalink) |
| References | <lvu67cwyypan.1uwuoyhnivv30.dlg@40tude.net> <att9q99g56phlhcf34vhs52i7fgdvfi2ak@4ax.com> <1v5cqtux7fm2t$.14sqgdhtzf3vw.dlg@40tude.net> |
Cross-posted to 2 groups.
richard <noreply@example.com> wrote in news:1v5cqtux7fm2t$.14sqgdhtzf3vw.dlg@ 40tude.net: > On Fri, 20 Jun 2014 20:13:10 -0700, Jürgen Exner wrote: > >> On Fri, 20 Jun 2014 10:20:59 -0400, richard <noreply@example.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. >> >> jue > > what if use Julian dates? Why on earth would you want to do *that*? Why would anyone store a date in a MySQL database using any data type other than DATE or DATETIME? > that throws all of your damn bullshit right down the drain don't it? There's one *more* thing you need to apologize for, Bullis. And you wonder why nobody wants to help you. How much longer will it be before you grasp the concept that the *external* *presentation* of date or date-time data can (and usually *should*) be different from the *internal* format in which it is stored?
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
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 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 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 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 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 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
csiph-web