# 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) 

<iframe 
  src="https://exploratory.io/note/2ac8ae888097/8536346149893898?embed=true"
  frameborder="0"
  width="100%"
  height="100%"
  >
</iframe>