Using of Global Variable

[system]

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…

Summary: sysdate() returns a native datetime datatype, it has no format. You can use to_char(sysdate(), ’ mm/dd/yyyy’) to convert a datetime into a string of your format.

---

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