in
All Tags » date » type (RSS)

Browse by Tags

  • type conversion failure (date field) in access update

    Using Access, I want to append a new record to tblOrders. Here is the code mySQL = "INSERT INTO tblOrders ( OrderID, CustomerID, ShipCity, OrderDate, ShipDate )" & _ "VALUES('NewOrderNumber', '199', 'Local', 'me.StockCheckDate', 'me.StockCheckDate'...
    Posted to Access (Forum) by microsoft on 11-11-2009

  • Change Data Type Decimal(8,0) into Date

    Can someone please help me with a query I can run to update a field data type from decimal(8,0) to a Date Field. Could I do this on my import query. select LASTMAINTAINEDDATE from GLTMST Could a do a CONVERT query?? Example: I have a field LASTMAINTAINEDDATE that was import as 20071110. I need to convert...
    Posted to SQL Server 2005 (Forum) by microsoft on 06-17-2009

  • Problem: Converting string to date type

    I'm trying to update a table and I'm stuck on a CAST/convert problem. Here's my query: UPDATE app_ResourceOrgAssignments_test SET startDate = CAST('1/1/' + DATEPART(Year, endDate) WHERE startDate IS NULL and endDate IS NOT NULL Basically I'm trying to set the startDate to the...
    Posted to SQL Server 2005 (Forum) by microsoft on 05-30-2009

  • Problem: Create table error based on date data type

    I'm attempting to do an exercise from Sam's Learn SQL in 24 hours with the following syntax. create table employee_pay_tbl (date_hire date); I'm getting this error and need help. IIt does not like the date data type? I'm a beginner... Server: Msg 2715, Level 16, State 7, Line 1 Column...
    Posted to Queries (SQL) (Forum) by microsoft on 05-27-2009
Page 1 of 1 (4 items)