Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Dealing with time format as string

Question
Nezla · Apr 12, 2022

Dealing with time format as string

Hi Guys,

I'm using  seconds counter then save those seconds in a field defined as string where eg. I do :

S time=30  

S time = $zt(time,1)  

Update myclass se timeSpent = :time

which now shows up as 00:00:30 if I do an sql query which good but the problem if I run a query to get average timeSpent I get 00:00.

having the field defined as integer would allow selecting avg but running a query in my Zen page wouldn’t show me a time format

so how can I get an average on my a filed defined as string in a sql query?

thanks

#Ensemble
Product version: Caché 2014.1

Source URL:https://community.intersystems.com/post/dealing-time-format-string