Re: set sqldatetimeformat / -editor option
1998-05-05 18:55:40
Thomas A. La Porte wrote:
> I have two completely unrelated questions for the list.
>
> 1) Is there any way, by using 'set sqldatetimeformat' or by
> some other method (perhaps similar to Oracle's to_char
> function), to have dates displayed without their timestamp
> information?
>
> In some cases, all I want to know is the date, and don't
> really care about the time. The output of any SELECT statement
> with a timestamp invariably ends up with multiple lines of
> output.
I use the following in my SQLs. (It will print the date portion only - good
luck)substr\(CHAR\(m.UPD_DATE\),1,10\) as \"Update Date\"
>
>
> 2) I noticed in the readme notes for v3.1.1.1 and v3.1.1.2 of
> the AIX server that there a new "EDitor" option that is a
> "toggle that lets you use the command line editor."
>
> Does this option actually work? Whenever I try it, I get
> the following message:
>
> ANS1107E Invalid option/value: '-editor'
>
> "It's a dog eat dog world, Thomas A. La Porte
> and I'm wearing milkbone underwear." DreamWorks SKG
> - Norm Peterson <tlaporte AT anim.dreamworks DOT
> com>
--
Peter Gill
Peter Gill
UNIX Systems Administrator
RACV Information Systems
550 Princes Highway
NOBLE PARK VIC 3174
P: +61 3 9703 6018
F: +61 3 9790 2559
mailto:Peter_Gill AT racv.com DOT au
|
|
|