on 09-19-2008 6:56 AM
Hi Everybody,
In a C application using SQLDBC to access MaxDB if i have to allocate space for holding the value returned by TIMESTAMP field from a table. How much space should i allocate to this variable.
For example:
In Oracle:
the space allocated is
m_size = sizeof(OCIDate);
In DB2:
sizeof(SQL_TIMESTAMP_STRUCT)
In MySQL:
sizeof(MYSQL_TIME)
Regards
Raja
From the net i see that TIMESTAMP in MaxDB confirms to ISO timestamp format. So, its stored in the format 'YYYY-MM-DD hh:mm:ss'
But then from Database Studio i see that 26 as the dimension for a a TIMESTAMP field. Can someone explain if this 26 means 26 bytes and if yes, why do we need 26 bytes to store 20 characters (including the null terminator)
Regards
Raja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Raja,
the Reference Manual is part of the documentation provided online.
In thread 'MaxDB documentation' a link is provided: http://maxdb.sap.com/doc/7_6/default.htm
In this documentation you can find a link to the 'SQL Reference Manual'.
Best regards,
Melanie
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.