customers_dob field DEFAULT '1970-01-01 00:00:01'
Posted: Thu Jul 21, 2022 6:57 am
hi All
The standard value of de customers_dob (in customers table) is '1970-01-01 00:00:01' ( i know the reason because timestamp...)
But the problem is, whenn customer don't give the dob, it's saved as '1970-01-01 00:00:01' and that makes problem with different things, as this date is also a "real" date, so for example birthday wishes automatic emails, will be sent on this date or my payment provider needs dob for verification and if it's not set it's asked for the birthday, but as it's set to '1970-01-01 00:00:01' the provider refuse the verification as the dob is no match.
and whenn customer whant to add DOB in customerprofile (account_edit.php) he see also 1970-01-01 00:00:01
Is there a other possibility? why its not "null" or "" ?
is there a workarround?
or is this really the way to go and i have to set always like this:
if ( ! empty( $order->customer['customers_dob'] ) && $order->customer['customers_dob'] != '1970-01-01 00:00:01')
thanks for the help
The standard value of de customers_dob (in customers table) is '1970-01-01 00:00:01' ( i know the reason because timestamp...)
But the problem is, whenn customer don't give the dob, it's saved as '1970-01-01 00:00:01' and that makes problem with different things, as this date is also a "real" date, so for example birthday wishes automatic emails, will be sent on this date or my payment provider needs dob for verification and if it's not set it's asked for the birthday, but as it's set to '1970-01-01 00:00:01' the provider refuse the verification as the dob is no match.
and whenn customer whant to add DOB in customerprofile (account_edit.php) he see also 1970-01-01 00:00:01
Is there a other possibility? why its not "null" or "" ?
is there a workarround?
or is this really the way to go and i have to set always like this:
if ( ! empty( $order->customer['customers_dob'] ) && $order->customer['customers_dob'] != '1970-01-01 00:00:01')
thanks for the help