How to use TO_CHAR function
To translate:

```sql
TO_CHAR(created_at at time zone 'Asia/Kolkata','DD-MON-YYYY') as date
```

You'll probably need to use NodeList:

```python
expr = NodeList((Txn.created_at, SQL('at time zone'), 'Asia/Kolkata'))
date_expr = fn.TO_CHAR(expr, 'DD-MON-YYYY')

...select(Txn.id, date_expr.alias('date'))
``` Tnx:)
@coleifer 
How to use postgress TO_CHAR function in peewee
In native sql query 
`SELECT id, TO_CHAR(created_at at time zone 'Asia/Kolkata','DD-MON-YYYY') as date  from txn order by id desc limit 5`
-------------------------------- result ------------------------------
 **id              date**
131;  "19-SEP-2018"
130;   "19-SEP-2018"
129;   "19-SEP-2018"
128;   "19-SEP-2018"
127;   "13-SEP-2018"

In peewee
```
class Txn(BaseModel):
    created_at = DateTimeField(null=True)
    class Meta:
        table_name = 'txn'
        schema = 'public'
```
what I figure out 


```
def getprvtxn(passenger_id):
    try:
        query_get_txn_his = Txn.select(
            Txn.id,
            fn.TO_CHAR(Txn.created_at,"at time zone'Asia/Kolkata'DD-MON-YYYY HH12:MIPM").alias('date')
        ).where(Txn.passenger == passenger_id).order_by(Txn.created_at).limit(30)
        print(list(query_get_txn_his.dicts()))        
        print("SQL ={}".format(query_get_txn_his.sql()))
        if query_get_txn_his.__sizeof__() > 0 and bool(query_get_txn_his):
            for result in query_get_txn_his:
                print result.id
                print(result.date)
    except Exception as e:
        cnf.is_error = True
        cnf.statuscode = cnf.Internal_server_Error
        tb.print_exc()
        return None

```
--------------------------- Peewee Result ------------------------
```
id = 16 date = at t8me zone'As8a/Kolkata'17-AUG-2018 02:29PM
id = 17 date = at t8me zone'As8a/Kolkata'17-AUG-2018 02:29PM
id = 32 date = at t8me zone'As8a/Kolkata'20-AUG-2018 12:56PM
id = 33 date = at t8me zone'As8a/Kolkata'20-AUG-2018 01:02PM
id = 34 date = at t8me zone'As8a/Kolkata'20-AUG-2018 01:13PM
id = 35 date = at t8me zone'As8a/Kolkata'20-AUG-2018 01:14PM
id = 36 date = at t8me zone'As8a/Kolkata'20-AUG-2018 01:14PM
id = 37 date = at t8me zone'As8a/Kolkata'20-AUG-2018 01:16PM
id = 38 date = at t8me zone'As8a/Kolkata'20-AUG-2018 02:20PM
id = 39 date = at t8me zone'As8a/Kolkata'20-AUG-2018 02:38PM


```
You notice that **_at t8me zone'As8a/Kolkata'_** is  append with **20-AUG-2018 02:38PM** which not the desire output. Plase me with correct soluntion and correct way to use postgress function in peewee:) 



