|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Converting string to datetime format
Dear all,
I am a new member to the forum and would like assistance on : 1. how to convert 8 char string to datetime format. 2. When i try to enter additional data on a datetime column, I get an error message saying 'unable to convert string data to datetime format' on a column that has 128 values already. Ta |
|
#2
|
||||
|
||||
|
date conversion depends on which database you're using
if it's mysql, you'll have to un- and re-string it into year-month-day sequence the second problem sounds like a tinyint auto_increment that has reached its upper limit rudy http://r937.com/ |
|
#3
|
|||
|
|||
|
I'm using Microsoft SQL 2000
|
|
#4
|
||||
|
||||
|
cast(stringfield as datetime)
|
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Converting string to datetime format |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|