As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
I have a maintain application that connects to an MS-SQL database. The user has requested that a timestamp be added to certain records when they are inserted or updated. I'd like to see what other developers are using to generate timestamps, and what data type they are using on the back end. I could use things like the today2() function, but wouldn't this result in an alpha type field? I want to use something that could make reporting simpler in the future, and would allow me to make use of the many reporting functions for times and dates.
I've searched for documentation on this but all I can find is info referring to reporting off of timestamps or converting, but nothing about generating them. Any advice to point me in the right direction would be appreciated.This message has been edited. Last edited by: Kerry,
Bryan Johnson WebFOCUS 7.7.03 Maintain Win 7 Excel, PDF, HTML