Postgresql 12 CAST now() to date not working

Question

I am finding strange why database is having following result:

    my1db=# select now()::date;
            now
    ----------------------------
    2020-10-08 19:57:24.483647
    (1 row)

But here is the result of my other datbase:

    my2db=# SELECT now()::date;
        now
    ------------
    2020-10-08
    (1 row)

My 1st DB is not casting as shown from My 2nd DB

1STDB OS - RHEL 7 dbversion - PostgreSql 12.2
2NDDB OS - RHEL 7 dbversion - PostgreSql 12.1

May I know what am I missing? It is the reason why I am not getting correct results from my applications

Edit (*removed images):
1STDB

template1=# \dC date
                                      List of casts
         Source type         |         Target type         |   Function   |   Implicit?
-----------------------------+-----------------------------+--------------+---------------
 date                        | text                        | (with inout) | yes
 date                        | timestamp without time zone | timestamp    | yes
 date                        | timestamp with time zone    | timestamptz  | yes
 timestamp without time zone | date                        | date         | in assignment
 timestamp with time zone    | date                        | date         | in assignment
(5 rows)

template1=# select castfunc::regproc from pg_cast where casttarget = 'date'::regtype;
        castfunc
------------------------
 pg_catalog."timestamp"
 pg_catalog."timestamp"
 pg_catalog."timestamp"
(3 rows)


template1=# select castfunc::regproc, proname, proowner, prosrc, rolname from pg_cast, pg_proc, pg_authid where casttarget = 'date'::regtype and castfunc = pg_proc.oid and proowner = pg_authid.oid;
        castfunc        |  proname  | proowner |        prosrc         | rolname
------------------------+-----------+----------+-----------------------+---------
 pg_catalog."timestamp" | timestamp |       10 | date_timestamp        | pgadmin
 pg_catalog."timestamp" | timestamp |       10 | timestamptz_timestamp | pgadmin
 pg_catalog."timestamp" | timestamp |       10 | timestamp_scale       | pgadmin
(3 rows)

2NDDB - cast behaves normally

psql (12.1)
Type "help" for help.

template1=# \dC date
                                      List of casts
         Source type         |         Target type         |  Function   |   Implicit?
-----------------------------+-----------------------------+-------------+---------------
 date                        | timestamp without time zone | timestamp   | yes
 date                        | timestamp with time zone    | timestamptz | yes
 timestamp without time zone | date                        | date        | in assignment
 timestamp with time zone    | date                        | date        | in assignment
(4 rows)

template1=# select castfunc::regproc from pg_cast where casttarget = 'date'::regtype;
    castfunc
-----------------
 pg_catalog.date
 pg_catalog.date
(2 rows)

template1=# select castfunc::regproc, proname, proowner, prosrc, rolname from pg_cast, pg_proc, pg_authid where casttarget = 'date'::regtype and castfunc = pg_proc.oid and proowner = pg_authid.oid;
    castfunc     | proname | proowner |      prosrc      | rolname
-----------------+---------+----------+------------------+----------
 pg_catalog.date | date    |       10 | timestamp_date   | postgres
 pg_catalog.date | date    |       10 | timestamptz_date | postgres
(2 rows)