What is the number of bytes taken by the varchar data type while t is storing?
And if we want to convert it to date which takes 4 bytes what is to be done
Doubt regarding the size
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The record schema will tell you that. The prefix is the number of bytes in the number that describes the length.
Convert to date using StringToDate() function. For this to work your string must contain a valid date according to the date format string you specify, or according to the project's default date format string if you do not specify one.
Convert to date using StringToDate() function. For this to work your string must contain a valid date according to the date format string you specify, or according to the project's default date format string if you do not specify one.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
ds
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For less than 30c (approximately Rs12) per day you can purchase premium membership which, among other things, will allow you to read the entire post. Premium membership is one of the ways that the hosting and bandwidth costs needed to keep DSXchange alive are covered. On that basis I can not accede to your request.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.