Blog

Конвертирую “05-Feb-18 5:44:00 AM” date = DateTime.ParseExact(reader[“DateTime”].ToString(), “dd-MMM-yy H:mm:ss tt”, CultureInfo.InvariantCulture) Exception: System.FormatException: ‘String was not recognized as a valid DateTime.’ Как решить вопрос?Read more

Why are date fields in D8 stored in the database as varchar rather than datetime (like they were in D7)?Read more

Tengo el siguiente campo en un modelo de Odoo V10 starting_date = fields.Datetime(‘Starting date’, default=’2018-01-01 00:00:00′) y quiero que el valor del default me coja la fecha actual pero que la hora sea la 00:00:00 o cualquier otro valor fijo para evitar que me ponga fechas del tipo 11:27:23Read more

Anyone who knows how to convert the T in the following query to readable datetime? https://finance.services.appex.bing.com/Market.svc/ChartDataV5?symbols=126.1.AAPL.NAS&chartType=5d&isEOD=False&lang=en-US&isCS=true&isVol=true Thanks in advance!Read more

Estou passando uma data inicial e final por parâmetro (conforme a imagem), como podem visualizar no localhost as barras (/) estou passando %20 e ocorre normalmente a geração dos gráficos, porém no servidor está acusando erro 500 e ao inspecionar vejo que tem a mensagem “string not was recognized datetime”. O que pode está ocorrendoRead more

I have a datetime field on a custom entity defined in baseFieldDefinitions(). This has set a default, which should be now. But when saving the entity, i get following error: Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘date’ at row 1: INSERT INTO {sale} (uuid, langcode, user_id, name, status, created,Read more

Technically I’m using mysqli. In MySQL I tried: ALTER TABLE products ADD FULLTEXT(created); Created is a DATETIME column. I also tried to change all Collation’s of that table to the same utf8 type but it wouldnt stick. Only changed the vachar in the table. Is it possible to do a FULLTEXT search on a DATETIMERead more

Quero que ao seleccionar uma data no date time picker, só pode selecionar uma data menor ou igual a data apresentada em (select u_replica from e_industrial.dbo.e1) na base dados. private void btn_search_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(“Data Source=…;Initial Catalog=Innux;Persist Security Info=True;”); conn.Open(); SqlDataAdapter SDA = new SqlDataAdapter(“select dbo.Alteracoes.Data, dbo.Funcionarios.numero as no,Read more

Привет всем. Есть вот такая строка: s = ‘2017-07-12T20:08:35.083Z’ Как ее сконвертировать в объект datetime?Read more

I am working with data which has a session id value which gets recycled over time (asp session ids from IIS to be exact). I am trying to give them a sequence so that each instance of an ASP_SESSION_ID don’t get grouped together. For example, the data would look like this. Same session id, usedRead more