Re: [Q] Formatting query results

From: Mr Cartier Hung <cartier_at_hk.super.net>
Date: 1995/05/07
Message-ID: <3oi4u3$5ip_at_tst.hk.super.net>#1/1


Alex Long (paladin_at_along.dialix.oz.au) wrote:
:
: In article <3nrfum$35g_at_ixnews2.ix.netcom.com>, Chuck Hamilton (chuckh_at_ix.netcom.com) writes:
 

: Try this,
 

: SELECT SUBSTR(FNAME,1,20)||', '||SUBSTR(LNAME,1,12) FROM PEOPLE;
: You can adjust the SUBSTR values to suit your names.

  Is it possible to format the DATE field so that it can display as 'YYYYMMDD' and 24 hrs format?

--

+-----------------+----------------------+--------------------------------+
| Cartier Hung    | Interested in:       | Email: cartier_at_hk.super.net    |
|-----------------|  Computer Graphics   |        cschung_at_cs.cityu.edu.hk |
|      \\|//      |  Digital Arts/Images |                                |
|     ( o o )     |  Parallel Computing  | Finger: cartier_at_hk.super.net   |
+--ooOo--U--oOoo--+----------------------+--------------------------------+
Received on Sun May 07 1995 - 00:00:00 CEST

Original text of this message