I have a time field formatted as hhmm however the hours field does not
add leading zeros. eg 09:01 is simple 901.
I want to get a standard format time out but,
mysql str_to_date('901','%k%i')
gives a NULL result.
A further test reveals that I can covert into the desired format but not
back.
Danny:
What if you just pad the string, does it work then?
str_to_date( LPAD( '901', 4, '0' ), '%k%i' )
Wes
On Jul 22, 2004, at 2:05 PM, [EMAIL PROTECTED] wrote:
I have a time field formatted as hhmm however the hours field does
not
add leading zeros. eg 09:01 is simple 901.
I want to get a