I have an interval field in a table for the timecard application. the field will calculate total work time of a user by using punch out time minus punch in time. I take a total of total work time in a week for a user and in my postgressql database it will show 40:30:22 (as in 40 hours 30 minutes and 22 seconds). When i do cfoutput for that field, it becomes: 0 years 0mons 0days 40 hours 30 minutes 22 seconds. Is There a way for it to just show 40:30:22 ? Thank you,
Related Questions in INTERVALS
- Qlik IntervalMatch to SQL
- Cut intervals to add specific dates
- Combination of Non-overlapping interval PAIRS
- MySQL query to get the number of read unique pages for book
- Number of outstanding shares per query
- Interval Trees adjacent intervals
- Countif rows are within 1,000 milliseconds or 1 second
- Select intervals between since and until parameters including those that overlap period
- Reactjs useState every second and scroll element at the same time not woking
- Cross timeline count across subscriptions for customers
- Removing overlapping events from data table with intervals
- Trouble with X Axis time units in Gantt charts with Mermaid via DiagrammeR
- The number of overlapping events SQL
- SQL combine two tables with date interval
- How to compute overlap time of two arrays of (price, time) elements
Related Questions in CFOUTPUT
- ColdFusion: how to access dynamic column names
- Coldfusion output string not defined
- Why is cfoutput being ignored?
- Bootstrap Modal INSIDE Coldfusion <cfoutput query> tags fails with "Invalid CFML construct"
- <cfoutput> With Many-To-Many Relationship
- Need help listing products in reverse order in old ColdFusion site
- cfoutput in cfset tag
- ColdFusion cffeed/cfoutput
- count total records for each user
- How can I cfoutput a JavaScript String?
- Conditional CF Record Count
- ColdFusion cfdump / cfoutput doesn't match query analyser results
- Why can I reference RecordCount on a query embedded in an object but I can't loop over it?
- Coldfusion set dynamic columns for query output
- cfml variable inside cfoutput text
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)