Title |
Test
Find
Oracle Like TimeStamp validator
|
Expression |
^((((((0[1-9])|(1\d)|(2[0-8]))\.((0[123456789])|(1[0-2])))|(((29)|(30))\.((0[13456789])|(1[0-2])))|((31)\.((0[13578])|(1[02]))))\.\d{4})|((29)\.(02)\.\d{2}(([02468][048])|([13579][26]))))(\s((0\d)|(1\d)|(2[0-3]))\:([0-5]\d)\:([0-5]\d)\.\d{7})$ |
Description |
Oracle like time stamp with format:
dd.MM.yyyy HH.mm.SS.xxxxxxx
Based on European full proved date format with easy changeable dot separator.
Optimized regular expresion. |
Matches |
29.02.2008 23:50:45.1234567 | 31.03.2007 00:01:01.0000001 | 30.04.1999 01:02:03.0000000 |
Non-Matches |
29.02.2009 23:50:45.1234567 | 31.04.2007 00:01:01.0000001 | 30.04.1999 01:02:03.0000 |
Author |
Rating:
Not yet rated.
Andrei Martin Aszodi
|
Source |
|
Your Rating |
|
Title: Oracle Like TimeStamp validator
Name: Scott Meyer Peimann
Date: 12/2/2008 1:58:36 PM
Comment:
This is a good timestamp validator, as far as it goes.
I think the leap year test is clever, and well done for the most part.
Just beware that this will fail on centuries not divisible by 400.
Cheers,
Scott
Title: Oracle TimeStamp Validator
Name: Loup Philippe
Date: 11/4/2008 7:35:23 AM
Comment:
I am using already and is working fine.
Title: Oracle TimeStamp Validator
Name: Loup Philippe
Date: 11/4/2008 6:59:09 AM
Comment:
I am using already and is working fine.
Title: Oracle TimeStamp Validator
Name: Loup Philippe
Date: 11/4/2008 6:55:14 AM
Comment:
I am using already and is working fine.
Title: Oracle TimeStamp Validator
Name: Loup Philippe
Date: 11/4/2008 6:54:55 AM
Comment:
I am using already and is working fine.