Home » U++ Library support » U++ SQL » Sql .sch / Date (moved)
Re: Sql .sch / Date (moved) [message #35666 is a reply to message #35379] |
Sun, 11 March 2012 19:30 ![Go to previous message Go to previous message](theme/default/images/up.png) ![Go to next message Go to previous message](theme/default/images/down.png) |
jjacksonRIAB
Messages: 221 Registered: June 2011
|
Experienced Member |
|
|
To match them you should probably use:
TABLE_(matable)
INT_ (ID) PRIMARY_KEY
DATE (SubscripDate)
END_TABLE
or:
TABLE_(matable)
INT_ (ID) PRIMARY_KEY
DATETIME (SubscripDate)
END_TABLE
using _ depending on whether first use of column name or not.
Since your table creation uses TIMESTAMP, I'm not sure how this differs on MySql. I use MSSQL and in that system I don't think that TIMESTAMP can be converted to a date. Your mileage may vary.
[Updated on: Sun, 11 March 2012 19:31] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Mon Jun 17 02:34:04 CEST 2024
Total time taken to generate the page: 0.02261 seconds
|