Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys...
I need to extract just time from a field which is DateTimestamp.... But i can't think of anything... The format is as follows:
'DD/MM/YYYY hh:mm:ss'
i have tried
time(DATETIME) as TransTime
time(DATETIME, 'hh:mm') as TransTime
But neither are working. Any suggestions please?
Regards
Hi,
What are the output of the two functions you are trying ?
You can use timestamp() function or maketime function.
if all the date-time values are having proper length at least for time part then maketime will work.
use maketime ( mid ( date, 12, 2 ), mid ( date, 16, 2 ), right ( date, 2 ) ) as time
Reg,
Shubhu
Dear
try it
=time(date(DATETIME,'DD/MM/YYYY hh:mm:ss'),'hh:mm')
it should be work. and above function is also working.
I tried both functions are working properly.
Thanks and Regards
Hi Blaze,
Try this...
TIME
(NOW(),'hh:mm:ss:TT')Hello,
First, get the right timestamp, then get the time part of it
=Time(TimeStamp#('08/03/2011 08:10:30', 'DD/MM/YYYY hh:mm:ss'))
Hope that helps.