tag:blogger.com,1999:blog-34020393.post3389753219187980151..comments2024-03-27T10:59:38.307-07:00Comments on Jim's PeopleSoft Journal: DateTimeToTimeZone with Invalid TimezoneJim Marionhttp://www.blogger.com/profile/12995110203807924786noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-34020393.post-3602987318095477482016-06-01T15:53:31.627-07:002016-06-01T15:53:31.627-07:00@Giri, yes, you store data in your base format, bu...@Giri, yes, you store data in your base format, but PeopleSoft uses the logged in user's time zone.Jim Marionhttps://www.blogger.com/profile/12995110203807924786noreply@blogger.comtag:blogger.com,1999:blog-34020393.post-84594484197726093732016-06-01T05:42:28.880-07:002016-06-01T05:42:28.880-07:00Jim,
I have a question on date.
If my data base ...Jim,<br /><br />I have a question on date.<br /><br />If my data base server is in IST timezone and employee is in PST. The %date always shows the Database server date. <br /><br />IN all our sql/PeopleCode we used %date and %currentdate. This will impact the user accessing in different time zone.<br /><br /><br />How people soft handled this?<br /><br />Regards,<br />giriGirihttps://www.blogger.com/profile/01655616277054752790noreply@blogger.com