Posts Tagged ‘ Date ’

Add User Register Date Column in WordPress 3.X and 4.X

2017/10/04
By
Modified: 2017/09/16
WP-Users-with-Date-Column

This solution was last tested on WordPress 4.1.1 in March 2015.   This solution was tested on WordPress 3.1 running on IIS7 and IIS 7.5.  It will work on WordPress 3.1.1, on 3.2.1, and on 3.5.1.    This solution was just tested on WordPress 3.8.1 and works very well. This solution adds a new column to your admin user page, and makes it sortable (optional).   Here are the steps. -01- Find wp-admin\includes\class-wp-users-list-table.php and make a backup copy of the file. Call it class-wp-users-list-tableORIG.php.   -02- Open wp-admin\includes\class-wp-users-list-table.php in your favorite editor.   -03- Find line function get_columns() {   -04- Add a new line of code ‘user_registered’ => __(‘Date’), after…

Read more »


How to Convert Julian Date to Gregorian in MS SQL

2017/09/20
By
Modified: 2017/09/16
SQL - Convert JUL to GREG

Julian date is stored in YYYDDD format, for example 12/31/99 will be stored as 99365 and 01/01/2017 will be stored as 117001. If you need to convert the date from YYYDDD to any conventional date format like dd/mm/yyyy in SQL use steps below. The idea is to convert year and date portions separately and them add them together and use CONVERT function to get any date format that you require. Here is a script that shows the conversion process step-by-step. SELECT -- Limit output for 9 rows TOP 9 -- 00 Julian date - 91244 FAEFTB, -- 01 Greg year - 1991 cast(left(CAST(FAEFTB as decimal)+1900000, 4) as char(4)) AS GREGYEAR, --…

Read more »