jean_5

How to convert a date that is in the format yyyy-mm-dd. For example: 2014-12-12 to Dec 12 2014?

I have the following view: ALTER VIEW [dbo].[vw_RelInclusaoGeralCivil] AS SELECT DISTINCT m.Nome AS MunicipioNome, au.Nome UsuarioNome, s.TipoId AS SolicitacaoTipoId FROM Solicitacao s INNER JOIN Unidade u ON s.UnidadeEntregaId = u.Id INNER JOIN Endereco e ON u.EnderecoId = e.Id INNER JOIN [IBGE.Municipio] m ON e.CodMunicipio = m.CodMunicipio INNER JOIN Terminal t …

I have the following code: //list is the result of the query of the database var list =[]; var _this = this, $div = _this.$div, opts = _this.settings, $table = $div.find(opts.tableSelector); var fieldsToShow = ["Right Identification", "Left Identification", "Total", "RIGHT IDENTIFICATION RELAPSE", "LEFT IDENTIFICATION RELAPSE", "Total", "IDENTIFICATION TOTAL IN "]; …

I have the following table: Region IdDescription IdUser Metropolitan Right 5 Metropolitan Left 6 Metropolitan Right 5 Metropolitan Left 6 Country Town Right 5 Country Town Left 6 Country Town Right 5 Country Town Left 6 Metropolitan Right 7 Country Town Left 8 And I want to query the kinds …

I have the following javascript code var list = [ { Date : '00/00/0000', DateStart: '00/00/0000', Name: 'string', ... ... }, { Date : '00/00/0000', DateStart: '00/00/0000', Name: 'string', ... ... } ]; var column = list.?; What can I do to the `column` variable has the Date value, for …

I have the following javascript code var list = [ { Date : '2014-12-31 12:23:43', DateStart: '1980-12-30 23:43:42', Name: 'Kate', ... ... }, { Date : '1978-05-21 23:43:65', DateStart: '1973-04-06 12:34:09', Name: 'John', ... ... } ]; And the following code to verify for regex pattern: for (var i in …

How can I convert html to image?

This code gets the data from the table to show in a table for the user using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Collections; using System.Collections.Generic; using System.Text; namespace Form { public class RelUse { public DateTime Date { get; set; } } public RelUse() { …

I have the following table User in my database Name(Varchar) DateOfBirth(datetime) Age(int) Name(Varchar) | DateOfBirth(datetime) | Age(int) John | 2014-12-20 23:59:59 | 0 Mary | 2014-12-20 23:59:59 | 1 How can i verify throught javascript if the field DateOfBirth of the table User of the database z is of type …

I have the following code if (list.Date[0] != 'undefined') { for (var i in list) { var date = list[i].Data; var year = date.substr(0, 4); var month = date.substr(5, 2); var day = date.substr(8, 2); var newDate = day + "/" + month + "/" + year + " " …

Hello, what can i do to convert a date that is dd/mm/yyyy to yyyy-mm-dd? public static Paginacao<Solicitacao> PaginarParaLote(int paginaAtual = 0, int itensPorPagina = 20, int? TipoId = null, long? ProtocoloId = null, int? StatusId = null, DateTime? DataSolicitacaoInicio = null, DateTime? DataSolicitacaoFim = null) { StringBuilder strWhere = new …

What is the main Difference between var $name and var name?

I already have a datepicker to get the start date and the final date, it already makes the validation when the user clicks only on the calendar, but when it's typed, it's not validated. So, i thought something like this: datePickerRange: function () { if ($(this).length != 2) return; var …

I have the following code: if (object.GroupBy == "Cities") $("body").children().find("td:first[name=Name]>").html("City"); if (object.GroupBy == "Banks") $("body").children().find("td:first[name=Name]>").html("Banks"); if (object.GroupBy == "User") $("body").children().find("td:first[name=Name]").html("Users"); <tr class="form-list-table-header"> <td class="" name="Name"></td> <td class="" name="Total">Total</td> </tr> <div><span>Group By</span></div> <select class="combobox" name="GroupBy"> <option value="Cities">Cities</option> <option value="Banks">Banks</option> <option value="Users">Users</option> </select> </div> If the user select Cities, the td is …

I have a table and i want that only appear the column that the user select in the combobox <table class="form-list-table" width="100%"> <tr class="form-list-table-header"> <td class="hidden" name="Nome">Municípios</td> <td class="hidden" name="Nome">Postos de Identificação</td> <td class="hidden" name="Nome">Colaboradores</td> <td class="" name="Total">Inclusões</td> </tr> </table> <div class="form-item combobox esquerda"> <div class="form-item-label inline ui-widget-content"><span>Agrupar por</span></div> <select …

I have the following code: isBigInt: function () { var val = bigInt(); if (bigInt(val.toString()).greaterOrEquals("-9223372036854775808") && bigInt(val.toString()).lesserOrEquals("9223372036854775807")) return true; else return false; } I have downloaded the biginteger library in the https://www.npmjs.org/package/big-integer , but this code does not get the correct number typed by the user.

I have the following code: if (filtro.FinalDate != null) { FinalDate = String.Format(" Data <= '{0}' ", filtro.FinalDate.GetValueOrDefault().ToString("yyyy-MM-dd") + " 23:59:59"); } But when I compile and type something in the FinalDate, the following message appears in the log: Could not convert string to DateTime: 18/11/2014. Path 'FinalDate', line 1, …

I need to do a search that specifies in witch line of the search that the information was found. For example: select * from table where height=100; this code returns 50 lines, but i want, for example, in that search, the person 'Matheus' was in the 28th line of the …

I have just installed node.js. When I open the cmd, I type "node -v" and the correct version appears, but when I type "rpm -v" appears the following message "rpm is not recognized as an internal or external command.". When this message appeared a little time ago, my professor was …

I have installed the npm install big-integer https://www.npmjs.org/package/big-integer to test if the number is in the specified range with this code: isBigInt: function () { var val = $(this).valueOf var valor = bigInt(val); var minimo = bigInt("-9223372036854775808"); var maximo = bigInt("9223372036854775807"); if (bigInt(val).greaterOrEquals(minimo) && bigInt(val).lesserOrEquals(maximo)) return true; else return false; …

What is the exception that verifies if the input is in the specified sql range?

I have the code if (!(row.IsNull("bigInt") || row["bigInt"].Equals(String.Empty))) { this.bigInt = Convert.ToInt64(row["bigInt"]); } But, it's give to me the error: Cannot inplicity convert type 'long' to 'int'. An explicit conversion exists (are you missing a cast?)

I have the code if (!(row.IsNull("bigInt") || row["bigInt"].Equals(String.Empty))) { this.bigInt = Convert.ToInt64(row["bigInt"]); } But, it's give to me the error: Cannot inplicity convert type 'long' to 'int'. An explicit conversion exists (are you missing a cast?)

I have this code: isTinyInt: function () { var val = $(this).val(); if (val >= 0 && val <= 255) return true; else return false; } Can I make sure with this that the number is in the tinyint range?

I want a parse to convert a number to different types of sql server data ranges available. For example, for an input to the firld of kind int I have parseInt, for another kind that is float I have parseFloat. How can i do parseTinyInt(), parseSmallInt(), parseBigInt(), parseDecimal(), parseNumeric(), parseSmallMoney(), …

what are the maximum values of javascript data types?