Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Formatting to_timestamp fields (Read 9280 times)
davidkornelson
YaBB Newbies
*




Posts: 2
Formatting to_timestamp fields
09.12.05 at 16:54:07
 
I am working with a table that has fields defined as timestamp(6).  However when I download the data, these fields are populated with 'Sample Data' and when I try to format the cells for uploading, I can't get rid of the single quotes (') at the beginning and end of the formated data...'to_timestamp(....)' should be to_timestamp(...).  Can anyone help with this?
Back to top
 
 
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Formatting to_timestamp fields
Reply #1 - 11.12.05 at 07:55:56
 
Which database type are you using?
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
davidkornelson
YaBB Newbies
*




Posts: 2
Re: Formatting to_timestamp fields
Reply #2 - 11.12.05 at 16:52:52
 
Oracle...the timestamp(6) format is: TO_TIMESTAMP('12/01/2005 08:00:00.00000 AM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM')
Back to top
 
 
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Formatting to_timestamp fields
Reply #3 - 12.12.05 at 13:48:01
 
I have built in the timestamp functionality for you. I have announced the support for the timestamp data type here: http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1134391429
 
Please see the release log how to get the new version:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1130772637
 
I have programmed it such that the timestamp will be put into the Excel cell as a date/time value. When you want the raw Oracle timestamp value please use the to_char function. So the following queries work fine:
 
select current_timestamp from dual;
select to_char(current_timestamp) from dual;
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1