in
All Tags » date » number (RSS)

Browse by Tags

  • ORA-00932: inconsistent datatypes: expected NUMBER got DATE using asp.net

    hi experts, i'm trying to retrive a recode from an oracle database table using asp.net,but i get problems with dates. here is the code,i traid every thing even the NLS_DATE_FORMAT Dim con As OleDbConnection con = PRD() Dim str As String str = "select * from table1 where aa = ? and ((to_date...
    Posted to ASP.NET (Forum) by microsoft on 04-28-2010

  • convert date to date number

    This is an easy quick 500pts. We all know that access and excel store dates as a number...right? I have a date in my access table 15/05/2005.... I need to convert this to the underlying numerical value.. I'm brain dead..so alil help please. ie 09/05/2005 = 38481 how do I get the second number...
    Posted to Access (Forum) by microsoft on 12-29-2009

  • How to convert week number and weekday to date

    I have to fields, consisting of * Week number * Weekday How can I find the date?
    Posted to Access (Forum) by microsoft on 08-24-2009

  • Convert date number to actual date

    I need to extract a date from an SOS accounting program that has stored it (like Access does) in a numerical format. Does SQL have a converstion available similar to CVDate? Using Access I can convert the number to a date with CVDate([FLD47]-36161), but that doesn't work in SQL.
    Posted to MS SQL Server (Forum) by microsoft on 07-14-2009

  • Convert Date to Week number in SQL

    Hi When I type the following in SQL Query Analyzer SELECT DATEPART(ww,GETDATE()) Result: 45 But the actual week number is 44 Is there anyways to fix this - since some years have 53 weeks and some 52 weeks Thanks, kris
    Posted to MS SQL Server (Forum) by microsoft on 07-11-2009

  • convert date to a number with vb.net

    how can i convert date to a number with vb.net example in vb6: Private Sub Form_Load() Text1.Text = Date End Sub Private Sub Command1_Click() Dim num num = Format(Text1.Text, "0") Text2.Text = num End Sub thanking you in advance From: yulyos@yahoo.com
    Posted to .NET (Forum) by microsoft on 07-07-2009

  • Convert number to date

    I need help in converting this number to a date 1070922 to 9/22/07 it is a number and not text. A formula or macro would work. It is in column K.
    Posted to Excel (Forum) by microsoft on 06-24-2009

  • Problem: Date shows as a number

    I received an Excel spreadsheet containing two columns with date values. However, the only way I can see the actual dates is if I select a specific cell, otherwise all I see is a number. e.g. 3/16/2007 shows as 39157 (left aligned) I've been trying to format the columns to a date using the Date and...
    Posted to Excel (Forum) by microsoft on 06-05-2009
Page 1 of 1 (8 items)