Month: May 2008

Tech

My Mobile Phones

Post author By Chaitanya
Post date May 11, 2008
No Comments on My Mobile Phones

Tech

Interesting fact about Microsoft Excel.

Post author By Chaitanya
Post date May 11, 2008
No Comments on 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.

Tech

SQL Date formatting function

Post author By Chaitanya
Post date May 11, 2008
No Comments on 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.