Hi,
I am inserting the date in database in the string format dd/MM/yyyy
but when I display the date in table the format is change and it display yyyy/MM/dd
Its a simple question Can anyone tell me that Why it occur?
Printable View
Hi,
I am inserting the date in database in the string format dd/MM/yyyy
but when I display the date in table the format is change and it display yyyy/MM/dd
Its a simple question Can anyone tell me that Why it occur?
I guess the date is not inserted as string but as date type.
When you select from your table the date then is displayed in the default format of a date.
Solution:
* insert the date "as a date"
* either use some special function in your select call (in Oracle you can tell the db to format a date (as a string) in some format)
* or "tell" your view (whatever you are using) to format dates the way you want to see them.
In my database field is by default date.
I think your logic works.Thanks