This topic is locked

Time Issue

1/18/2013 9:34:07 PM
PHPRunner General questions
T
Tempus_Erus author

HI,
Not vitally important, but I have an issue that is 'strange'.
In a field set as time with the time picker as per PHPR I recieve the below email(as programmed) based on stats entered:
2013-01-22 00:00:00
All is ok, save for 00:00:00!!! I have reduced the field size, omitted the time and played with every parameter in PHPR (6.2).....but I still have this bizarre time exist ......always at 00:00:00!!!
Why?
Any understanding would be good,
Thanks in advance
A

Sergey Kornilov admin 1/19/2013

It looks like field type in the database is DATETIME. Set it to TIME or to VARCHAR if you only want to store time values there.

T
Tempus_Erus author 1/24/2013

Thanks Sergey.
Already done that and double checked.
Works fine within the program, prints correctly etc, however the issue is only apparent when the field is emailed?
I also note that the field in the email is formatted different than what is in the database. In the field I store DD/MM/YYYY.
When this field is added to an email the format is MM/DD/YYYY....along with the aforementioned 00:00?

Sergey Kornilov admin 1/25/2013

I guess you need to modify the code that sends the email applying formatting to this field. Right now it sends date value the way it stored in the database (yyyy-mm-dd hh:mm:ss).