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
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