can not convert '01/01/1900 00:00:00' to a Timestamp

I would like to do this
INSERT INTO ita_badgeage VALUES ( '01/01/1900 00:00:00')

I have got this error
"cannot convert 01/01/1900 00:00:00 to a Timestamp"

i try this but I have got the same problem  :    set option
PUBLIC.timestamp_format = 'DD/MM/YYYY HH:NN:ss';


thank for your help

evincent@itlink.fr


0
Emmanuel
8/10/2000 9:54:20 AM
sybase.sqlanywhere.general 32637 articles. 22 followers. Follow

2 Replies
3045 Views

Similar Articles

[PageSpeed] 20
Get it on Google Play
Get it on Apple App Store

No you change the date_order, not the date_format.  Date_format is for
DISPLAY purposes only.

set option date_order='MDY'
If this is via ODBC you must issue this AFTER connecting:

set temporary option date_order='MDY'

--
David Fishburn
Sybase - iAnywhere Solutions
Professional Services
Please only post to the newsgroup

EBFs and Whitepapers
http://www.sybase.com/products/mobilewireless/anywhere/

"Emmanuel Vincent" <evincent@itlink.fr> wrote in message
news:o9Y$vJrAAHA.203@forums.sybase.com...
> I would like to do this
> INSERT INTO ita_badgeage VALUES ( '01/01/1900 00:00:00')
>
> I have got this error
> "cannot convert 01/01/1900 00:00:00 to a Timestamp"
>
> i try this but I have got the same problem  :    set option
> PUBLIC.timestamp_format = 'DD/MM/YYYY HH:NN:ss';
>
>
> thank for your help
>
> evincent@itlink.fr
>
>


0
David
8/10/2000 12:37:04 PM
evincent@itlink.fr




"David Fishburn" <fishburn@spam_off_sybase.com> a �crit dans le message
news: UmhYnksAAHA.167@forums.sybase.com...
> No you change the date_order, not the date_format.  Date_format is for
> DISPLAY purposes only.
>
> set option date_order='MDY'
> If this is via ODBC you must issue this AFTER connecting:
>
> set temporary option date_order='MDY'
>
> --
> David Fishburn
> Sybase - iAnywhere Solutions
> Professional Services
> Please only post to the newsgroup
>
> EBFs and Whitepapers
> http://www.sybase.com/products/mobilewireless/anywhere/
>
> "Emmanuel Vincent" <evincent@itlink.fr> wrote in message
> news:o9Y$vJrAAHA.203@forums.sybase.com...
> > I would like to do this
> > INSERT INTO ita_badgeage VALUES ( '01/01/1900 00:00:00')
> >
> > I have got this error
> > "cannot convert 01/01/1900 00:00:00 to a Timestamp"
> >
> > i try this but I have got the same problem  :    set option
> > PUBLIC.timestamp_format = 'DD/MM/YYYY HH:NN:ss';
> >
> >
> > thank for your help
> >
> > evincent@itlink.fr
> >
> >
>
>


0
Emmanuel
8/10/2000 1:40:38 PM
Reply:

Similar Artilces:

Bug with a datetime of '1753-01-01 00:00:00' ??
1> select @@version 2> go --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Adaptive Server Enterprise/12.5.3/EBF 12330 ESD#1/P/Sun_svr4/OS 5.8/ase1253/1900/32-bit/FBO/Tue Jan 25 07:02:08 2005 (1 row affected) For the life...

Urgent: series_date = ' 0000-00-00 00:00:00' ?
Hi, I just upgraded one of my Bugzilla servers from 2.20 to 2.20.1 and now I can't create charts anymore. In the apache error log I see: chart.cgi: Use of uninitialized value in concatenation (.) or string at Bugzilla/Chart.pm line 237 It seems the $datefrom is the problem on line 221 [...] my $datefrom = $dbh->selectrow_array("SELECT MIN(series_date) " . "FROM series_data " . "WHERE series_id IN ($series_ids)"); [-> $datefrom = '0000-00-00 00:00:00' ] $...

Converting '2008-03-17T00:00:00-04:00:00' to a DateTime object
I'm dealing with some Yahoo API's and the documentation says: To obtain one day's worth of data in US Eastern Standard Time (EST), specify: startDate: 2007-01-15T00:00:00-05:00 endDate: 2007-01-15T00:00:00-05:00So i get the server's TimeZone information likeDim ts As TimeSpan = TimeZone.CurrentTimeZone.GetUtcOffset(i_StartDate)ts = TimeZone.CurrentTimeZone.GetUtcOffset(i_StartDate)which results in "-04:00:00"and March 13th, 2008 is the day i am starting at, so how do i put the date and timezone information together in .NET (VB or C# is fine) so i can creat...

display DB default (1900-01-01 00:00:00.000) datetime in gridview as blank
Hi there and thanks in advance for any answer. I have a db table where I store production task items. In that table I have a field which is a datetime. I'm currently displaying the production tasks on a gridview. My problem is that when the manager does not specify a the datetime when he first fills out the order form, on the gridview I get the infamous 1900-01-01 00:00:00.000 db default time, and thats just nice.  Is there a way to simply display blank?? Or is there a way to input blank or null to the db?? Adam How are you inserting the records into the database if nothing i...

NULL DATE IS NOT NULL BUT 01/01/00 00:00
The following works if I'm in design mode, but it doesn't in the release version. I got a column field with a mask as mm/dd/yy hh:mm, when the value is null, it shows 00/00/00 00:00 which is what I want, but when user wants to delete an existing date, let's say 06/05/02 12:00, instead of going back to 00/00/00 00:00 it goes to 01/01/00 00:00. I am using PB 8 Ent and W2K operating system, database is in SQL2000. If I look at the value in the database it got 01/01/00 instad of <NULL>. try check 'blank is null' @ datawindow field setting... & allow ed...

3.0.7 Issue
This is a section of my 01.00.00.SqlDataProvider script for a custom module I made: CREATE PROCEDURE {databaseOwner}{objectQualifier}GetEmpAppsModules @EmpAppModuleID int AS SELECT t.[EmpAppModuleID], t.[ModuleID], t.[CreatedByUserID], t.[CreatedDate], [CreatedByUserName] = u.FirstName + ' ' + u.LastName FROM {databaseOwner}[{objectQualifier}EmpAppsModules] t LEFT OUTER JOIN {databaseOwner}[{objectQualifier}Users] u ON t.CreatedByUserID = u.UserID WHERE t.[EmpAppModuleID] = @EmpAppModuleID When I upload the PA zip file through Host/Module...

SQL statement failed: (-157) Cannot convert 1992/mrz/01 00:00:00.0 to a timestamp
Hi, I have a problem with DBRemote. The errormessage is: "SQL statement failed: (-157) Cannot convert 1992/mrz/01 00:00:00.0 to a timestamp" Sybase SQL Remote Message Agent Version 6.0.3.2833 is running on linux 2.2.13 (SuSE 6.3). What's wrong? Ciao...Patrick Ulmer Hi, > "SQL statement failed: (-157) Cannot convert 1992/mrz/01 00:00:00.0 to a > timestamp" Ahhhh, I have installed the german version of ASA on the remote system. How can I force dbremote to generate an timestamp with YYYY/MM/DD and not YYYY/MMM/DD? Ciao...Patrick...

Set dateTime variable to 01/01/1900 00:00
Just a very simple question and I know most of you may be able to answer this. I want to set the value for a datetime variable to 01/01/1900 00:00 (the format of this is dd/MM/yyyy hh:mm). I try to do this using the following code: Dim strDate as String = "01/01/1900 00:00"Dim ciCultureInfo As New CultureInfo("en-GB") Dim dtDate as DateTime = Convert.ToDateTime(strDate, ciCultureInfo) I get the error: String was not recognized as valid date time. Can someone help me out on this?  Basically, I just need to set the value for the dtDate variable to 01/01/1900 00:0...

Cast from string "00/00/00" to type 'Date' is not valid
hi, I am trying to solve this proble, for over 2 days and still.. i couldnt solve it  i am getting this error: Run-time exception thrown : System.InvalidCastException - Cast from string "00/00/00" to type 'Date' is not valid. how do i put "00/00/00" or even a NULL value ??  DATEE is diffine as datetime type in the data basenewNode = xmlTos.CreateElement("DATEE") newNode.InnerText = ="00/00/00" 'If Not IsDate(newNode.InnerText) Then ' newNode.InnerText = DBNull.Value 'System.DBNull.Value.ToString 'End If If n...

Inserting a NULL value instead of 01/01/1900 12:00:00 a.m.
Hello, I'm trying to save data from my asp.net page but even when I'm adding the NULL value in my query is still saving the 01/01/1900 12:00:00 a.m. in my datetime field This is my code:   Dim sqlConn As SqlConnection Dim sqlCmd As SqlCommand Dim strConnection, resul, COP, USD As String strConnection = ConfigurationManager.ConnectionStrings("SIPConnectionString").ConnectionString sqlConn = New SqlConnection(strConnection) COP = Replace(TxtCOP.Text, ".", ",") USD = Replace(TxtUSD.Text, ".", ",") resul = "Insert into...

BOClean Update File released- FILEDATE: 05/10/05
FILEDATE: 05/10/05 - 00:39:01 (US EDT) (04:39:01 GMT/UTC) Fifteen new nasties today for a total of 6377 UNIQUE trojans (36,911 trojans, worms, rootkits, adware, spyware, keyloggers, "dialers" and other malware in total, including all variants) covered in today's update for BOClean 4.12. To UPDATE your BOClean 4.12, doubleclick on your BOClean traybar icon and select "check for update" to have BOClean 4.12 automatically collect and install your update for you. BOClean 4.12 is designed to perform an autoupdate if left configured to do so. If you h...

Problem with a Delete statement error: Syntax error (missing operator) in query expression '(([FechaTramite]>=7/18/2005 12:00:00 AM) AND ([FechaTramite]<=7/26/2005 12:00:00 AM))'.
Hi All:I have a simple page with two Calendars and I want to delete all the rows in the DB beteewn two dates selected from the calendars.My code is the following:  protected void Button1_Click(object sender, EventArgs e) { String qry; string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("/mensajeria/mensajeria.mdb;"); qry = "DELETE FROM [envios] WHERE (([FechaTramite]>=" + Calendar1.SelectedDate + ") AND ([FechaTramite]<=" + Calendar2.SelectedDate + "))"; TextBox1.Text = Calendar1.SelectedDate.ToString(); TextBox2.Text = Calenda...

Date format of 0000-00-00 or 00:00:00
I am converting a MySQL database to SQL server 2000. I noticed that in one of the database fields in a table, they set a default value for the field as 0000-00-00. Is this okay for a default value for SQL Server 2005 ? How about a default value of 00:00:00 ? Will '00:00:00' is ok, while '0000-00-00' is invalid. A quick test in SQL Server: create table testDate (id int,t smalldatetime default '00:00:00') insert into testDate(id) select 1 create table testDate1 (id int,t smalldatetime default '0000-00-00') insert into testDate1(id) select 1 The 2nd insert will fail because '0000-00-00'...

PB4 and 00/00/00
I have an application developed in PB4. On some of my dates, I would like to display 00/00/00. When I do this though, it is displayed and stored as 01/01/00. How can I obtain the desired results? Thank You, P.J. Borandi pborandi@nb.net I had the same problem. The workaround is to use four digit dates. It will clear out 00/00/0000 with no problem. Brian CPD Mark A. Berardi wrote in message ... >I have an application developed in PB4. On some of my dates, I would like >to display 00/00/00. When I do this though, it is displayed and stored as >01/01/00....

Web resources about - can not convert '01/01/1900 00:00:00' to a Timestamp - sybase.sqlanywhere.general

Resources last updated: 1/18/2016 11:48:59 PM