Re: Date Insert Problem in mySQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Jassim Rahma" <jrahma@xxxxxxxxxxx> wrote in message
news:u8F8iG%23eFHA.584@xxxxxxxxxxxxxxxxxxxxxxx

> I am using C# to insert a date value from the DatePicker into a DateTime
> filed in mySQL database.. I am using the following syntax:
>
> '" + datePicker.Value + "'

Does this fix it...?

'" + datePicker.Value.ToString("yyyy/MM/dd") + "'

> I also triend it withour the ' and with #

It needs the apostrophe, not the hash.


.

Relevant Pages

  • Date Insert Problem in mySQL
    ... I am using C# to insert a date value from the DatePicker into a DateTime ... filed in mySQL database.. ... I am using the following syntax: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Filter / "Between" help
    ... > I found that the form was not displaying what I refer to as record ... > Could you supply an example of how I would modify my syntax should I ... Assuming you mean DateAdd() I'm not sure what you mean. ... DateTime result so you can use it anywhere that you need a DateTime value. ...
    (microsoft.public.access.formscoding)
  • Re: unable to update password in database
    ... yeah i agree with that syntax issue ... UPDATE members ... password should be stored in the mysql database, ...
    (comp.lang.php)
  • Re: Using variables in Dynamic SQL
    ... > Thank you for the posts and I have now managed to resolve the other ... My revised syntax is, ... > DECLARE @StartDate datetime ... > If anybody else knows how to resolve this or a workaround then please ...
    (microsoft.public.sqlserver.programming)
  • Re: Convert varchar to datetime in SQL 2000.
    ... I want to convert datatype of type varcharto datetime value. ... The syntax is the same, just specify datetime as the type instead. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)