About: isa:172609655   Sponge Permalink

An Entity of Type : prov:Entity, within Data Space : webisadb.webdatacommons.org associated with source dataset(s)

AttributesValues
rdf:type
prov:value
  • Its working.quote:Originally posted by bandiIf you do not have permissions to alter table structure... --Just check the following illustration:SET DATEFORMAT DMYGODECLARE @Gen varchar (7) = '10-2012', @Sg varchar(7) = '12-2012'SELECT cast(DATEDIFF(month,CAST ('01-'+@Gen AS DATE),CAST('01-'+@Sg AS DATE)) AS VARCHAR)as PPNOTE: Better to change data types of both columns to DATE type--Chandu
prov:wasQuotedFrom
is prov:wasDerivedFrom of
Alternative Linked Data Views: ODE     Raw Data in: CXML | CSV | RDF ( N-Triples N3/Turtle JSON XML ) | OData ( Atom JSON ) | Microdata ( JSON HTML) | JSON-LD    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 07.20.3217, on Linux (x86_64-pc-linux-gnu), Standard Edition
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2012 OpenLink Software