#62 Copying Oracle Dates

Squirrel SQL
closed-works-for-me
Core (461)
5
2015-01-08
2002-09-06
Anonymous
No

When trying to copy a DATE datatype from the tables,
only the time portion will be copied, leaving teh date
portion out. Ive noticed this while using an oracle
database, and pasting into an excel spreadsheet.

Thankx for the great product!

Pete
pfowler@tempo.com.au

Discussion

  • Colin Bell

    Colin Bell - 2002-09-11
    • status: open --> closed-works-for-me
     
  • Colin Bell

    Colin Bell - 2002-09-11

    Logged In: YES
    user_id=233132

    Hi Pete,

    This works for me. You'll probably find its the default
    formatting in the cells of the spreadsheet. You can test it
    by pasting into a text document through Notepad and seeing
    if that works. Also some dates appear funny due to the date
    handling in Excel. For instance if I copy a date from
    Squirrel "2/10/5027 9:46:39" and paste that into Excel I
    see "46:39.0" but if I paste it into Notepad I see
    "2/10/5027 9:46:39".

    Col

     
  • Colin Bell

    Colin Bell - 2002-09-12
    • assigned_to: nobody --> colbell
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks