time dates - Search results

Mailing lists  >>  pgsql-hackers  >>  Thread

2025-05-21 21:22:06 | Re: [PoC] XMLCast (SQL/XML X025) (Jim Jones)

date  *   - TIME [WITH/WITHOUT TZ]      -> xs:time  *   - TIMESTAMP [WITH/WITHOUT TZ] -> xs:dateTime  *  * These mappings are defined

Mailing lists  >>  pgsql-hackers  >>  Thread

2024-11-13 03:16:42 | Re: [PoC] XMLCast (SQL/XML X025) (Jim Jones)

date.  * ii)  If the type designator of SQLT is TIME WITH TIME ZONE, then let XT be xs:time

Mailing lists  >>  pgsql-hackers  >>  Thread

2024-11-12 17:59:44 | Re: [PoC] XMLCast (SQL/XML X025) (Robert Haas)

date into the JSON-preferred format happened to use slightly different time zone handling than

Mailing lists  >>  pgsql-hackers  >>  Thread

2024-11-11 22:43:17 | Re: [PoC] XMLCast (SQL/XML X025) (Jim Jones)

time I also took a look on how other databases implemented it.[1] I agree. It would be nice to know which cases those are. However, invalid inputs should normally return an error, e.g. SELECT