Db2

[Paidithalli]

When I use varchar_format(timestamp, ‘mm/dd/yyyy’) column name is missing in the result 

my query is like this 

select columnname1 , columnname2, varchar(timestamp column, ‘mm/dd/yyyy’) from tablename where timestsmp >= ‘2019-02-20-00.00.00.000000’;

[Ram30]

ee probs kante friend valla friend valla uncle ki oche probs ee interesting baa.. ave patukura 

[Paidithalli]

DATE() function work avvatledhu. DB Lo timestamp column datetime lo undhi . User expecting it as timestamp format ... so checks pettina.. convert chesthunna .. 

UI unte atleast response object  ki  .GetDate.ToString(“d”) pedithe saripoyedhi. But aa option ledhu .. 

[Paidithalli]

Varchar_format(timestamp, ‘mm/did/yyyy’) as columnname 

ani pedithe vosthundhi ...

 

thanks .... thread closed