Tagged questions

83 results found

help with an update statement and CAST()August 16, 2011

i have a table wich i need to update my intention is to update the field increasing 100 to its current value, unfortunately that value is stored as string for example '0165' would like to turn

4

views

0

votes

5

answers

cast in sqlAugust 16, 2011

hlo i want to make a request sql will return distinct date in a table. The date are the attribut 'dat_achat' in my table 'facture' the type is timestanp and where i 'm execute the

3

views

0

votes

1

answers

Using cast in group by clauseAugust 16, 2011

Hi, I am new to Firebird database. How to use cast in Group by clause. I have written SQL statement in this way SELECT CAST(CSTARTTIME AS DATE) FROM TESTTABLE GROUP BY CAST(CSTARTTIME AS DATE) It is g

4

views

0

votes

7

answers

cast vs convertAugust 16, 2011

how do i decide which to use: cast() or convert() in t-SQL

5

views

0

votes

3

answers

query php in iseriesAugust 16, 2011

I am connecting a page of php to a servant iseries ibm, this it(he,she) connects me without problem but when I try filterthe information the following mistake goes out for me Warning: odbc_exec(): SQL

5

views

0

votes

9

answers

Why is it possible to cast List<? extends Shape> to be a list of anything at all without any sort of warning?August 16, 2011

Why does this compile? &#160; &#160; public class Shape {}; &#160; &#160; public class Square extends Shape {}; &#160; &#160; public void doStuff() { &#160; &#160; &#160; &#160; List&lt;? extends Shap

6

views

0

votes

5

answers

Typecasting Custom ClassesAugust 16, 2011

Hello, I&#39;m having difficulty with the following user class. Basically what&#39;s happening, is it works one developers machine, and works on the production web server, but does not work on another

32

views

0

votes

3

answers

System.InvalidCastException: Specified cast is not valid, Microsoft Visual Studio, C#August 16, 2011

I am writing a program which runs a stored procedure to return the data, then output the content to a CSV file. &#160; When running my stored procedure, I get all the values back. &#160;However, when

43

views

0

votes

7

answers

Various questionsAugust 16, 2011

True or false? If false, please let me know what is the ? Thanks. There is no private variables in classes. They can only be declared public. You can define a contructor but not a destructor in classe

8

views

0

votes

8

answers

Converting a date field e.g. 10 Mar 2010 to full text in the format March 10th, 2010August 16, 2011

Is there a quick way of converting datetime values in to &#39;Month n(st/nd/rd/th), Year&#39; in t-sql?

11

views

0

votes

5

answers