datetime format in GB-PVR

[psycik]

you'd be better to:

Code:

SQLParameter newParm = command.Parameters.Add(item_id)
newParm.DbType = System.Data.DbType.DateTime

or

Code:

SQLParameter newParm = new SQLParameter
newParm.DbType = System.Data.DbType.DateTime
newParm.Name = "name"
command.Parameters.Add(newParm)

[zehd]

you'd be better to:

Code:

SQLParameter newParm = command.Parameters.Add(item_id)
newParm.DbType = System.Data.DbType.DateTime

or

Code:

SQLParameter newParm = new SQLParameter
newParm.DbType = System.Data.DbType.DateTime
newParm.Name = "name"
command.Parameters.Add(newParm)

OK. I think I have this in the code correctly now.

By problem now is to recover some messed up records. The data is there, just the format of the date string is wrong.

I want to pull the date string out (as is?) and then reformat it and put it back...

manual_start_time (and end time) is

Code:

2009-03-26 10:00:00 PM

I'm not sure of the date formatting is occurring.

It's really a one time thing as I'm trying to recover some shows in my database.

For VB, I had to do this

Code:

SQLparm = New SQLiteParameter
            SQLparm.DbType = System.Data.DbType.DateTime
            SQLparm.ParameterName = "@manual_start_time"
            SQLparm.Value = .manual_start_time
            command.Parameters.Add(SQLparm)

            SQLparm = New SQLiteParameter
            SQLparm.DbType = System.Data.DbType.DateTime
            SQLparm.ParameterName = "@manual_end_time"
            SQLparm.Value = .manual_end_time
            command.Parameters.Add(SQLparm)

[psycik]

you may have to go through the db and edit them by hand?? how else will your program know what format they are/need to be if you've entered them in wrong?

[zehd]

you may have to go through the db and edit them by hand?? how else will your program know what format they are/need to be if you've entered them in wrong?

Actually, I thought a date is a date.

It's a perfectly vaild date, just GB-PVR doesn't like it. Sure I put it there like it was a string, but isn't that what the sqli3 typing is all about, it shouldn't have let me?

[zehd]

Sorry, I know nothing about VB.Net syntax. I'm sure googling "VB.NET Prepared Statements" will return some examples.

Thanks. I think this might be what I'm looking for.

I'm going to have to rest my brain though...