thank you for the answer
my problem actually is that the type date is on the first column, the type number is on the second column, and represent seconds from 1/1/2000, that I need to convert in a normal date, hours:minuts:se conds format.
lucaluca
Last Activity: Nov 30 '09, 12:37 PM
Joined: Nov 1 '09
Location:
-
data types
DATA_EVENTO DATE
SECONDO_EVENTO NUMBER(10,0)
example actual output format (for example, in csv format)
;"01-NOV-09";"310430379" ;
example output format that I try to create (for example, in csv format)
;"01-NOV-09";"15:01:27 ";
that is, in other way: "01-NOV-09, 15:01:27" ore something like thatLeave a comment:
-
his is the format (it is a "vista" from a table)
COLUMN DATA TYPE
DATA_EVENTO DATE
SECONDO_EVENTO NUMBER(10,0)
Comment for the "DATA EVENTO": it is the correct day of the timestamp
Comment of the "SECONDO EVENTO": it is the exact second day of the
timestamp, but from 1/1/2000)
Conversion that I need: new...Leave a comment:
-
convert number to date
I have a Table that represent many istant time with two column:
Column 1:
istant time that is writted by a number 10 characters that are the seconds from 1/1/2000;
Column 2:
also in this column there is a data, that is year (YYYY): months (MM) ; Day (DD).
I need to rapresent the visible colum outside converting the first colum, or if is useful, also the second column, with the format:
...
No activity results to display
Leave a comment: