Synchronize NTP Server and Change Timezone in Oracle Linux

I’m using Oracle Linux 6.5. For synchronize your machine with the known NTP/Time server you can change the config in /etc/ntp.conf look at the file, and you can see in the bottom the NTP server destination : server 127.127.1.0 fudge 127.127.1.0 stratum 10 server 0.id.pool.ntp.org restrict 0.id.pool.ntp.org mask 255.255.255.255 nomodify notrap noquery The first two…

Oracle SQL : Search a value in a delimiter value column

Interesting idea.. Documentation : Hi I am wondering how to write an SQL statement for SQL Server 2008 that Selects entry’s where a column contains a value, now the value within the column is a comma delimited list (usually – there could only be one entry (and no leading comma)) so what In checking for…

Unix: find files or folder between modified date & delete

find all folder that modified in between the datetime find /home/yours/ -newermt “20120101 00:01:00” -not -newermt “20170702 06:00:00” find all folder that modified in between the datetime and delete find /home/yours/ -newermt “20120101 00:01:00” -not -newermt “20170702 00:00:00” -exec rm -rf {} \; Sort All folder by datetime descending / count all appearance ls -lart…

Note: Epoch, unix Timestamp to date, SQL, converter

https://www.epochconverter.com/ Note if the epoch is 13 digits, you need to divide it with 1000, if it’s 10 digits epoch you don’t need to divide it with 1000 (TIMESTAMP ‘1970-01-01 00:00:00’ AT TIME ZONE ‘UTC’ + numtodsinterval(1204104116656/1000,’second’)) AT time zone tz_offset(‘PST’); or just GMT with.. select (TIMESTAMP ‘1970-01-01 00:00:00′ + numtodsinterval(1204104116656/1000,’second’)) from dual; If you…