Thread: Check Format in SQLite
10-22-08, 11:08 #1Registered User
- Join Date
- Jan 2005
Unanswered: Check Format in SQLite
if've got some Fields in my SQLite DB with a "Time-Format". If i insert data no error occurs when i use "7:45" instead "07:45". Can i check if there is a leading zero, and "add" it if not? Mayby a trigger would be the solution, but i dont know how to do this.