Sysdate to date format

[system]

If it is a date, then the mapping is simply sysdate(). A date datatype does not have a format, the conversion from date to string has.

120×120 10.4 KB

Converting date, datetime datatypes: What format does a date datatype have, dd/mm/yyyy? dd.mm.yyyy? yyyy-dd-mm?? Answer: None. A date/datetime datatype has no format at all. Only if you use implicit conversion from date to char or vice versa, then you use the database session default format which can be different for each database, even each client connecting to the same database. Example: print(sysdate()); If you click on validate all you will see you have an implicit conversion from dateti…

---

Werner Daehn (BOB member since 2004-12-17)