Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following field in my database:
[Date/Time] with format YYYY/MM/DD hh:mm PM --> "2012/09/17 11:31 PM"
First I want to convert this to:
[Date/Time] with format: DD.MM.YYYY hh:mm --> ""17.09.2012 23:31"
Further I have to adjust the time from Eastern Time (GMT -4) to GMT + 2 (+6 hours). Is there a function for that. Or do I have to calculate it by extracting the hour and adding 6 hours?
After that I want to extract year,month,day, time(hour would be enough).
I have to admit I have some problems understanding the syntax of the date(formatting) functions. Any help is appreciated.
Regards,
Peter
, It's alright, you have got the solution, that is more important. Have a nice day.