1
  • DateTime to DateTimeOffset

    hi, We currently have a table with over a billion rows recorded with a datatype of datatime that spans across 6 years. we would like to change the datatype to date time offset but after expermenting with doing that it puts a 00:00 for the offset. Is there a way to do it and insert the correct...

    Bru5 pointsBadges:
  • How to convert LONG to CLOB or to VARCHAR type in select statement

    Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...

    SamG15 pointsBadges:
  • Data type in VB.NET

    The following question was recently submitted by a user via e-mail: I used to use a creation of datatype in vb 6. It combined the use of strings and numbers, then the the length of the datatype was read and placed on the disk.\ on a specific area. When you went back to the disk to retrieve the...

    JennyMack4,280 pointsBadges:
  • Converting Integer to Short in VB6

    I need to convert integer to short and short to integer. I need a .dll which I can use in my VB6 project. Please help.

    Deepakrnayak15 pointsBadges:
  • How to convert VBA decimal DataTypes

    I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300...

    McNitro255 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following