I am using informix database for storing the data. Everything is storing correctly. But I need to change the datatype format of the Timecol. Now the TimeCol format is yyyy-mm-dd hh:mm:ss:0000. While storing the data,the Timecol is coming like that. I want to change the 0000 from the Timecol. Is it possible to change the datatype format of Timecol in informix database?
Informix database issue: Changing the datatype format
148 Views Asked by George At
1
There are 1 best solutions below
Related Questions in VBA
- Toggle "conversation view" in Outlook with VBA
- VBA query - sort text in alphabetical order in Word
- Excel - Visual Basic, macro with autofill "1"
- Getting Run-time error '13': Type Mismatch using .Find
- Getting website metadata (Excel VBA/Python)
- How to use VBA to bold just some text
- VBA Code to filter and get values from csv to excel worksheet
- Azure Batch for Excel VBA
- How can i printpreview multiple excel sheets, with the names of the sheets located in a range?
- Comparison the data of two row and unique number highlight and show below of it
- Is there a way to pass Today's date as a command line argument to Excel from a Windows Task Scheduler Job
- Xero Upload Invoice file using API
- Visual Basic For Application Related Question
- Trying to give color to column field headers in pivot table with vba
- General error handler: If any error in UserForm other than msgBox: Err.Description
Related Questions in INFORMIX
- Informix Golang client package
- How to resolve this error when using OpenQuery in SQL Server to extract data from an Informix database
- Trigger/Stored Procedure causing sql error 127 Informix 12.10.FC10
- Update a huge number of rows without lock entire table in Informix
- Informix ODBC Driver][Informix]A character to numeric conversion process
- Update rows in an Informix database by incrementing serial numbers
- Informix - get DB Server Name / Alias for connected Session
- How can get full name from INFO TABLES at Informix DB
- Is there a way to get the sql statement about the creation of the row type?
- How to connect to informix DB using data direct informix driver and python on Linux
- IBM VS.NET SE Integration & Extensions package did not load correctly
- IBM Informix Error "-556 Cannot create, drop or modify an object that is external to the current Database"
- Find opaque types in the Informix database
- Informix: SQL does not accept double quote to surround a string
- Update a table in informix (an entire field)
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
it seems that you cannot change it but adjust it with extend.
for example