Dbspaces y Chunks
Hi all: Is it possible to see the creation date of DBSPACES and CHUNKS. Thank you _________________________________________________________________ Windows Live Messenger, la nueva generación de tu MSN. http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar
For the dbspaces :
database sysmaster;
select name,l2date(created) from sysdbstab;
________________________________
=
"Juan Pablo" =
<in4mixperu@hotma =
il.com> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Dbspaces y Chunks [10171] =
17/10/2007 17:14 =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi all:
Is it possible to see the creation date of DBSPACES and CHUNKS.
Thank you
_________________________________________________________________
Windows Live Messenger, la nueva generaci=F3n de tu MSN.
http://imagine-msn.com/minisites/messenger/default.aspx?locale=3Des-ar
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Run "select name, 12date(created) from sysdbstab" I get 201 syntax error.
"select name, created from sysdbstab" will show "name rootdbs -
created 1094010659".
The field"created" is an integer field. How do we convert its value to a
date value?
Regards,
Long N.
=======================
"Philippe
Pignon1" To: ids@iiug.org
<philippe.pignon@ cc:
fr.ibm.com> Subject: Re: Dbspaces y Chunks [10178]
Sent by:
ids-bounces@iiug.
org
18/10/2007 02:40
AM
Please respond to
ids
For the dbspaces :
database sysmaster;
select name,l2date(created) from sysdbstab;
________________________________
=
"Juan Pablo" =
<in4mixperu@hotma =
il.com> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Dbspaces y Chunks [10171] =
17/10/2007 17:14 =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi all:
Is it possible to see the creation date of DBSPACES and CHUNKS.
Thank you
_________________________________________________________________
Windows Live Messenger, la nueva generaci=F3n de tu MSN.
http://imagine-msn.com/minisites/messenger/default.aspx?locale=3Des-ar
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Disclaimer:
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No confidentiality
or privilege is waived or lost by any mistransmission. If you receive this
correspondence in error, please immediately delete it together with any
attachments from your system and notify the sender. You must not disclose,
copy or rely on any part of this correspondence if you are not the intended
recipient.
Any opinions expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be
the opinions of Ruralco Holdings Limited or any of its subsidiaries
(collectively "Ruralco").
Although all care has been taken to screen this communication for viruses,
neither the sender nor Ruralco warrants that any communication via the
Internet is free of errors, viruses, interception or interference.
Information is distributed without warranties of any kind.
The function that I like to use is DBINFO. It will takes two arguments=
when converting
a time_t in to a datetime. The first argument is string constant
"utc_to_datetime" and
the second is the integer to convert. See example below.
select name, dbinfo("utc_to_datetime",created),
dbinfo("utc_to_datetime",created)::DATETIME YEAR TO MONTH,
dbinfo("utc_to_datetime",created)::DATETIME YEAR TO DAY,
dbinfo("utc_to_datetime",created)::DATETIME YEAR TO HOUR
from sysdbstab
John
=
"Long Nguyen" =
<lnguyen@ruralco. =
com.au> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: Dbspaces y Chunks [10334] =
11/07/2007 04:51 =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Run "select name, 12date(created) from sysdbstab" I get 201 syntax erro=
r.
"select name, created from sysdbstab" will show "name rootdbs -
created 1094010659".
The field"created" is an integer field. How do we convert its value to =
a
date value?
Regards,
Long N.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
"Philippe
Pignon1" To: ids@iiug.org
<philippe.pignon@ cc:
fr.ibm.com> Subject: Re: Dbspaces y Chunks [10178]
Sent by:
ids-bounces@iiug.
org
18/10/2007 02:40
AM
Please respond to
ids
For the dbspaces :
database sysmaster;
select name,l2date(created) from sysdbstab;
________________________________
=3D
"Juan Pablo" =3D
<in4mixperu@hotma =3D
il.com> =3D
To
Sent by: ids@iiug.org =3D
ids-bounces@iiug. =3D
cc
org =3D
Subj=3D
ect
Dbspaces y Chunks [10171] =3D
17/10/2007 17:14 =3D
=3D
=3D
Please respond to =3D
ids@iiug.org =3D
=3D
=3D
Hi all:
Is it possible to see the creation date of DBSPACES and CHUNKS.
Thank you
_________________________________________________________________
Windows Live Messenger, la nueva generaci=3DF3n de tu MSN.
http://imagine-msn.com/minisites/messenger/default.aspx?locale=3D3Des-a=
r
***********************************************************************=
=3D
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=3D
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
Disclaimer:
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No confidential=
ity
or privilege is waived or lost by any mistransmission. If you receive t=
his
correspondence in error, please immediately delete it together with any=
attachments from your system and notify the sender. You must not disclo=
se,
copy or rely on any part of this correspondence if you are not the inte=
nded
recipient.
Any opinions expressed in this message are those of the individual send=
er,
except where the sender expressly, and with authority, states them to b=
e
the opinions of Ruralco Holdings Limited or any of its subsidiaries
(collectively "Ruralco").
Although all care has been taken to screen this communication for virus=
es,
neither the sender nor Ruralco warrants that any communication via the
Internet is free of errors, viruses, interception or interference.
Information is distributed without warranties of any kind.
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=