jadachDevClub member 2/6/2023 | |
Might be easier to build that in your SQL Editor. |
D
|
david powell author 2/6/2023 |
I agree!! that is the approach I have taken before, but I just thought there has to be a way to format date times into a string! All other aspects of java and c# seem to cover everything I need.... except for managing dates which seem to be a black art..... |
D
|
david powell author 2/7/2023 |
Either its too straightforward or there is no answer! I am going to go back to using good old mysql to create the necessary string (which it does so easily - date_format(dob, '%d/%m/%Y') AS dobstring ), and when I have a moment write a function myself to provide some datetime utilties..... |
jadachDevClub member 2/7/2023 | |
This should work for view as custom value = data["firstname"].ToString() + ' ' + data["lastname"].ToString() + ' ' + DateTime.Parse(data["dob"]).ToString("dd-mm-yyyy"); |