database Year Day Month but visual show Day Month Year

database Year Day Month but visual show Day Month Year

DaffyDaffy Posts: 2Questions: 1Answers: 0

database Year Day Month but visual show Day Month Year

i been using datatables, but i want on my website in the backend, to show me day month year in ascend/descend way
when i do that however in my database it takes the day first so when i use desc asc it work not correct, i want in the database to take year only but it needs to display day month year visual on my backend.

is this possible? maybe can in the database have it as year day month and on display visual in backend as day month year?

maybe some code like $date y-d-m convert/parse to d-m-y
https://www.youtube.com/watch?v=r_JW1PDZlZo i seen this

Answers

  • colincolin Posts: 5,549Questions: 0Answers: 970

    Hi @Daffy ,

    This thread here should help - it shows how date formats can be converted.

    Cheers,

    Colin

  • DaffyDaffy Posts: 2Questions: 1Answers: 0

    http://live.datatables.net/kapexuke/1/edit

    i need it to stay this format ddmmyy but it must asc desc with the year.

    found a way to more demonstrate what i mean hope it helps

  • colincolin Posts: 5,549Questions: 0Answers: 970

    Hi @Daffy ,

    Try this here - it's telling DataTables what date format to expect.

    Cheers,

    Colin

Sign In or Register to comment.