1

How to cast '2015-11-13 00:00:00' (text or timestamp) to '2015-11-13'(date) in Enterprisedb (EDB) ?

With 4 queries below:

1/ SELECT '2015-11-13 00:00:00'::date ; --> result: "2015-11-13" 
2/ SELECT date ( '2015-11-13 00:00:00' ) ;
3/ SELECT cast ( '2015-11-13 00:00:00' as date) ;
4/ SELECT to_char('2015-11-13 00:00:00'::timestamp, 'yyyy-mm-dd'::text);

In EDB 9.3 , just one query no.4 can cast. And PG 9.3 , all queries can do.

Are there still any ways to cast date in EDB ?

EDIT: With EDB :

    1/ SELECT '2015-11-13 00:00:00'::date ; --> result: "2015-11-13 00:00:00" 
    2/ SELECT date ( '2015-11-13 00:00:00' ) ; --> result: "2015-11-13 00:00:00" 
    3/ SELECT cast ( '2015-11-13 00:00:00' as date) ; --> result: "2015-11-13 00:00:00"  
    4/ SELECT to_char('2015-11-13 00:00:00'::timestamp, 'yyyy-mm-dd'::text);  --> result: "2015-11-13"  
  • All of them should work in EnterpriseDB. What exactly is the error you get? – a_horse_with_no_name Nov 13 '15 at 10:53
  • I will clarify my post . With Enterpriseb, only the query number 4 (select to_char....) can work as I wish. I do not know why query number 1 can not cast. I think , EDB do not have "date" data type. – Luan Huynh Nov 13 '15 at 11:06
  • 4
    EDB tries to be Oracle compatible, and in Oracle a DATE contains a time part, maybe that's the reason. If that is, you need to check if you can disable the Oracle compatibility. – a_horse_with_no_name Nov 13 '15 at 11:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.