我有一个通知表如下|id|user_receiver|user_sender|post_id|action|date|is_read这里user_sender是发通知的人，user_receiver是收到通知的人，post_id是帖子id，action可以是like,comment等，is_read是1如果它被receiver读取else0我想获取登录用户的所有通知我正在使用的查询是SELECTid,user_receiver,user_sender,post_id,action,max(date)asdate,is_readFROMnotificationWHEREuser_rece

TLDR:Thefollowingcodeisruninthedifferentdatabases,Oracle:selectsysdatefromdualSQLiteselectdatetime('now')WhendoingSession.CreateSQLQuery(cmd).UniqueResult()theresultisaDateTimewhenworkingagainstOraclebutastringwhenworkingagainstSQLite.ItfeelslikeabugintheSQLitedriverandahacktocheckthereturnedtyp

TLDR:Thefollowingcodeisruninthedifferentdatabases,Oracle:selectsysdatefromdualSQLiteselectdatetime('now')WhendoingSession.CreateSQLQuery(cmd).UniqueResult()theresultisaDateTimewhenworkingagainstOraclebutastringwhenworkingagainstSQLite.ItfeelslikeabugintheSQLitedriverandahacktocheckthereturnedtyp