Monthly Archives: August 2013

Getting first day of year Oracle SQL

SQL to get the first day of the current year: SQL to get the first day of the current month: SQL to get the last day of year: Have fun 🙂  

Posted in Uncategorized | Leave a comment

Extracting only date from a datetime field

In Oracle, to extract only the date from a datetime field, use the code below: Suppose your field UPDATE_DTTM has datetime stamp of a transaction – say ‘2013-08-01 02:30:31’ would not return any rows. Because, by default in Oracle, ‘2013-08-01’ … Continue reading

Posted in Oracle, PeopleSoft, SQL | Leave a comment

Get physical memory in Unix

The command displays details about memory in general. displays memory in MegaBytes. This command works on Red Hat and Ubuntu. Perhaps there are other variants too.

Posted in Uncategorized | Leave a comment

Getting only filename from full file path in Unix

Posted in Uncategorized | Leave a comment