Disclaimer

All of the topics discussed here in this blog comes from my real life encounters. They serve as references for future research. All of the data, contents and information presented in my entries have been altered and edited to protect the confidentiality and privacy of the clients.

Wednesday, June 29, 2011

'Date' defined by repository with timestamp information

It's been a while since the last post.Today, I just want to talk about something we run into on our project related to defining 'date' using repository variable.Defining a dynamic variable that returns yesterday's date is pretty easy by just adding the following statement in the initialization block:select sysdate-1 from dualThe result shows that it also comes with hours and seconds after the date, like so:Now changing the statement to select trunc(sysdate...
Related Posts Plugin for WordPress, Blogger...