mORMot Open Source

xchinjo

Member

From: Thailand

Registered: 2016-04-29

Posts: 41

Website

How to SQL Command Extract Date like yyyy/mm/dd from TModTime

How to SQL Command Extract Date like yyyy/mm/dd from TModTime  and TCreateTime ? My RDBMS is MySQL.

---

Jongruk Aripoo

mpv

Member

From: Ukraine

Registered: 2012-03-24

Posts: 1,571

Website

Re: How to SQL Command Extract Date like yyyy/mm/dd from TModTime

TModTime & TCreateTime designed for internal (inside a Delphi code) use. If you need to deal with TModTime on the MySQL level you should write a MySQL function - see SynCommons.TimeLogToDateTime