Datetime from mysql table

Setup, Configuration and Use Beginners
1

hi i am new to openhab.
I could not display the time stamp from mysql db [missing something?]
inside PHP :
$time_reading= date(“h:i:s”,strtotime($row[“time_reading”]));
$mqtt->publish("/home/pool/water_time/time",$time_reading,0);
Inside ITEMS:
DateTime WaterTime “[%1$tH:%1$tM:%1$tS]” { mqtt="<[broker:/home/pool/water_time/time:state:default]"}
Inside sitemap:
Text item=WaterTime icon=“clock” label="Update"
any help is appreciated
thanks

2

You are overriding the Item’s label by using the “label=Update” in the sitemap. Remove that and you should see your formatted date time (or - if the Item is undefined).