Skip to content Skip to sidebar Skip to footer
Showing posts with the label Format
Add 30 Days For Date In Db

Add 30 Days For Date In Db

Post a Comment
I have publish up date and publish down date in my DB. Currently they are both same dates. How do I… Read more Add 30 Days For Date In Db
Datetime String To Date, In Time And Out Time

Datetime String To Date, In Time And Out Time

Post a Comment
I have attendance record table like this +----------------+---------+-----------------------+ | NI… Read more Datetime String To Date, In Time And Out Time
C# Convert String To Datetime Without Time

C# Convert String To Datetime Without Time

Post a Comment
It seems like it is not possible what I want(at least according to some articles i have read). But … Read more C# Convert String To Datetime Without Time
Oracle Sqlldr Timestamp Format Headache

Oracle Sqlldr Timestamp Format Headache

Post a Comment
I'm struggling to get sqlldr to import a csv data file into my table, specifically with the fie… Read more Oracle Sqlldr Timestamp Format Headache
Oracle Convert Raw To Date Format

Oracle Convert Raw To Date Format

Post a Comment
I have a RAW field in my Oracle database that represents the date of user registered in system. The… Read more Oracle Convert Raw To Date Format
Sql Format Time Object From 24 Hour To 12

Sql Format Time Object From 24 Hour To 12

Post a Comment
Is there a way to convert a time object to a 12 hour format in SQL? I can't nessessarilly use d… Read more Sql Format Time Object From 24 Hour To 12
How To Format A Number Column In Oracle?

How To Format A Number Column In Oracle?

Post a Comment
I try to spool output in a nice way, so i am formatting all VARCHAR2 columns to a5. However, my pro… Read more How To Format A Number Column In Oracle?
C# Error : Input String Was Not In A Correct Format

C# Error : Input String Was Not In A Correct Format

Post a Comment
I was getting this error: 'Input string was not in a correct format.' Here is my Code: … Read more C# Error : Input String Was Not In A Correct Format
Comma's Causing A Problem Using Bulk Insert And A Format File

Comma's Causing A Problem Using Bulk Insert And A Format File

Post a Comment
I'm trying to import .CSV files using BULK INSERT on SQL Server and a Format File. I have creat… Read more Comma's Causing A Problem Using Bulk Insert And A Format File
Sql Auto Converts Decimal To Numeric When Select & Insert

Sql Auto Converts Decimal To Numeric When Select & Insert

Post a Comment
I have SQL Server 2008 R2 and linked SQL Server 2012. When I do the following SELECT * INTO dbo.Loc… Read more Sql Auto Converts Decimal To Numeric When Select & Insert
Add $ And Round 2 Decimal Places Sql

Add $ And Round 2 Decimal Places Sql

Post a Comment
I am looking to format an ouput which is created by a sub-query, this sub-query produces a calculat… Read more Add $ And Round 2 Decimal Places Sql
Sql Date Format [h]:mm:ss Like Excel Does, Beyond 24 Hr

Sql Date Format [h]:mm:ss Like Excel Does, Beyond 24 Hr

Post a Comment
There is a translation for Excel built-in date format [h]:mm:ss in T-SQL or any SQL platform? exam… Read more Sql Date Format [h]:mm:ss Like Excel Does, Beyond 24 Hr
Common Date Format Function For Oracle-sql And Mysql

Common Date Format Function For Oracle-sql And Mysql

Post a Comment
I need to write the common queries for MySQL and Oracle databases. Problem occurs when I have to pu… Read more Common Date Format Function For Oracle-sql And Mysql
C# Convert String To Datetime Without Time

C# Convert String To Datetime Without Time

Post a Comment
It seems like it is not possible what I want(at least according to some articles i have read). But … Read more C# Convert String To Datetime Without Time