How to Insert Javascript function between sql query ??

Question

Is there any way to insert java-script function between the query ??

For example :: In an query, i have stored date of birth like this 10101990 in the database, it means 10/10/1990, but I have display it in-front of page but in certain format like 10.10.1990 by using one java-script function.

Please suggest me any way ??

Answer 1

You can manipulate with data values in jquery6 just before display it like this

Answer 2

1. You should not be storing date as a string on the database. This might have a lot of issues. You have to store date as, well, a Date
2. You have to fetch this using a query using a language like Java or PHP.
3. When you get the date in the screen, you can format it in javascript, if required. However you can format it in PHP or Java. For java see SimpleDateformat.

See also this question.