ADSM-L

SQL syntax

2006-03-27 09:18:26
Subject: SQL syntax
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 27 Mar 2006 09:14:40 -0500
Hello Everyone,

I have run the following select statement, but I would like to run it from
the command-line and as tabdelimited so that I can import it into a
spreadsheet.  How can I format the last_write_date column so that I can see
the date & time?  When I do run this as tabdelimited it cuts off a majority
of the last_write_date information.  Any suggestions would be appreciated.
Thanks!

select
volumeusage.node_name,volumeusage.filespace_name,volumeusage.stgpool_name,volumeusage.volume_name,volumes.last_write_date
 from volumeusage,volumes where node_name='NAS_SERVER_2_OFFSITE' and
last_write_date > current_timestamp - 2 days order by
filespace_name,volume_name

      NODE_NAME: NAS_SERVER_2_OFFSITE
 FILESPACE_NAME: /
   STGPOOL_NAME: TAPE_NDMP_OFFSITE
    VOLUME_NAME: N00020
LAST_WRITE_DATE: 2005-11-27 01:30:25.000000

      NODE_NAME: NAS_SERVER_2_OFFSITE
 FILESPACE_NAME: /
   STGPOOL_NAME: TAPE_NDMP_OFFSITE
    VOLUME_NAME: N00020
LAST_WRITE_DATE: 2005-12-11 09:19:33.000000


********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************

<Prev in Thread] Current Thread [Next in Thread>
  • SQL syntax, Joni Moyer <=