note 68113 added to ref.datetime

Here are some rough patterns for matching some different date styles for building your own date conversion functions. The excel patterns relate to what you would find in MS Excel. ######################################### # Patterns for matching different date styles: # Using Perl style pattern matching for preg_match: /* Explained: unix - unix timestamp dates excel_date - Excel date stamp like "38911". excel_dt - Excel date/time stamp like "38911.4726469907". excel_time - Excel time stamp like ".4726469907". excel_dot - This one accepts either an Excel date stamp like "38911" or an Excel date/time stamp "38911.4726469907". */ ######################################### $unix_pattern = '/^(\d{10})$/'; $excel_date_pattern = '/^(\d{5})$/'; $excel_dt_pattern = '/^(\d{5})\.+(\d+)$/'; $excel_time_pattern = '/^\.+(\d+)$/'; $excel_dot_pattern = '/^(\d{5})\.*(\d*)$/'; ######################################### # Usage: $orig_v = "38911.4726469907"; if(preg_match($excel_dt_pattern, $orig_v, $matches)) { print "excel_dt_pattern $unix_v = $orig_v"; }#End of if value is a usuable excel date/timestamp: ######################################### ---- Server IP: 66.163.161.117 Probable Submitter: 144.226.173.68 (proxied: 172.19.134.127) ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/ref.datetime.php Edit -- http://master.php.net/note/edit/68113 Del: integrated -- http://master.php.net/note/delete/68113/integrated Del: useless -- http://master.php.net/note/delete/68113/useless Del: bad code -- http://master.php.net/note/delete/68113/bad+code Del: spam -- http://master.php.net/note/delete/68113/spam Del: non-english -- http://master.php.net/note/delete/68113/non-english Del: in docs -- http://master.php.net/note/delete/68113/in+docs Del: other reasons-- http://master.php.net/note/delete/68113 Reject -- http://master.php.net/note/reject/68113 Search -- http://master.php.net/manage/user-notes.php