Hi All, Since we need to use data type 'timestamptz' in PostgreSQL to handle timestamp with time zone, can someone state the correct format of the input.
I have used DBReport mediator to insert timestamp with the following parameter <parameter value="2015-02-16T21:41:00.000-0800" type="TIMESTAMP"></parameter> but it gives the exception ERROR - NativeWorkerPool Uncaught exception java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] at java.sql.Timestamp.valueOf(Timestamp.java:202) When I edit the format from '2015-02-16T21:41:00.000-0800' to 2015-02-16 21:41:00.000' everything worked fine. AFAIK timestamptz is used include timezone, therefore can someone provide an input on this Thanks, Sohani Sohani Weerasinghe Software Engineer WSO2, Inc: http://wso2.com Mobile : +94 716439774 Blog :http://christinetechtips.blogspot.com/ Twitter : https://twitter.com/sohanichristine
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
