Date format differ....

Hi,

When we pull date values using the same code [notification] (different environment) each environment different db, but dates are same in both db tables.

How should I used TO_CHAR at the time of retrieving date from db using notification…?

Regards,
Sam

I generally configure data fields to use java.util.Date. That way timestamp format variations aren’t an issue.

Hi Rob,

We can use the TO_CHAR in our notification it server our purpose. By the way we need to install a jdbc fix for the same.

Regards,
Sam