My Application is connecting to 3 type of database like : MS Sql Server 2005, Oracle 11i, MySQL.
I have a LoginLog Table, where I have 2 nos. of column as Login and Logout. In MySQl and Oracle the above column's datatype are Timestamp and its working fine.
I wants the same way in My sql server the datatype should be timestamp. its working fine. but when i am inserting the data the data is storing in binary format
ex : 0x00000000000007D3
like this, when i am also fetching the rows its also showing like this.
So my question is how can I store the exact format of timestamp as stored in Oracle and MySQL?
Ex : select current_timestamp.
Please help me.