Categories
Tech

My Mobile Phones

Categories
Tech

Interesting fact about Microsoft Excel.

Today I woke up to the fact that – Microsoft Excel can store only 65,536 rows per sheet.
Exporting data from any other tool like TOAD, will write the extra rows, if any, to a new sheet.
Thanks Nagu for this knowledge. I never knew it earlier.

Categories
Tech

SQL Date formatting function

TO_CHAR(date column to format , ‘DD-Mon-YYYY’) = ’10-May-2008′

THis function comes handy to do quick date comparisions.