How to show date column as string with specific date format

# How to show date column as string with specific date format like %d-%m-%y

Suppose you have POSIXct column in your data frame and you see value as `2016-01-06 19:17:38` in table view and you want to see the data in `%d-%m-%Y` format. So here is how you can do it.

## original column

So in this example,  `X4` column is the one that has datetime values.

![](/Users/hidekoji/.exploratory/projects/How_To_Markdowns_920766777d10/markdown_output/image-1507392371904.png)

## Convert and format with as.character function

you can use as.character with format argument like below.

```r
as.character(X4, format = "%d-%m-%Y") like below.
```

![](/Users/hidekoji/.exploratory/projects/How_To_Markdowns_920766777d10/markdown_output/image-1507392396382.png)

## Convertd column

This changes the `X4` columns like this in (%d-%m-%Y) format.

![](/Users/hidekoji/.exploratory/projects/How_To_Markdowns_920766777d10/markdown_output/image-1507392500186.png)