I am a newbie to Pervasive and I am trying to fetch all records from Patient table where the Date of birth of Patient is not '11/30/0002'
The Birthdate is stored in MM/DD/YYYY format in the system
Requesting your assistance
Asked
Active
Viewed 1,556 times
2
-
1Date of birth of patient is of String type or Date type? – Pallav Kabra Sep 03 '18 at 20:55
-
Regardless of the datatype of the column, `where dob <> '11/30/0002'` should work. – Bohemian Sep 03 '18 at 21:01
1 Answers
2
If the field is defined as a date, then you can use the standard format to restrict the data. For example:
select * from Patient where birthdate <> '0002-11-30'
The date format YYYY-MM-DD. If it's not in that format, you can convert it using various functions. For example:
select right('06/05/1995',4) + '-' + substring('06/05/1995',4,2) + '-' + left('06/05/1995', 2)
mirtheil
- 8,952
- 1
- 30
- 29