|
Your code must be doing something to change the data. The SQL should return exactly what is stored in the database for each record.
|
|
|
|
|
Can you share a sample of the code?
|
|
|
|
|
Sorry, yeah it was code issue, thanks for all your support friends.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
Sorry for a so stupid question.I am new beginer in C# and ASP.net.
Now I am writing the code for my web connect to database.
I am confuse about the function and procedure.
In VB, I store it in .vb file and then I can call in any form.
How can I do the same in website project asp.net.
|
|
|
|
|
|
Hi All.
I have SQL Server, link to Oracle DB.
In the SQL server I have a T-SQL command
select Moto.ne_code,
Moto.supplier_id,
Moto.ne_type_id,
Moto.sta_datetime,
from PMCALCULATE..[PM_TOOL].[MOTOROLA_CELL_HOURLY_KPI] Moto
and I get the result.
But the sta_datetime in the result is not ok
it is similar to: 2016-02-03 00:00:00 00000000
How to format it to yyyy/mm/dd hh24
|
|
|
|
|
What you are getting is a DATETIME data type which is correct. If you want to display it in a particular format then user CONVERT to get the format you need.
You MUST store the data in your SQL Server table as DATETIME, NEVER store DATETIME as a VARCHAR.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have try
select
convert(datetime2(0),Moto.sta_datetime) as Sta_Date1,
convert(datetime,Moto.sta_datetime) as Sta_Date2,
But the result is not as i want
All The result is:2016-02-03 00:00:00
I Want date only and time only
How can I do this.
|
|
|
|
|
|
Where are you using the result:
storing it in the database - do NOT format the data
displaying it in a UI - the UI needs to do the formatting
using it in a report - the report needs to do the formatting
exporting it to a file - this is the ONLY scenario where you should convert the datetime to a string (varchar) convert(varchar(20),DateValue,103) is an example.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I only Want to get Yesterday data from Oracle store in the SQL database.So that why I want to get exacly date to compare with the date in the SQL Database.
|
|
|
|
|
If Oracle has a DATE type (no time component) then in your query convert the datetime to date and filter the incoming values. Other wise use a range of datetime to determine the date you need > '2016-4-1 11:59:59' and < '2016-4-3 00:00:01'
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Now I Use T-SQL
select
Moto.ne_code,
Moto.sta_datetime,
convert(varchar(10),sta_datetime,111) as Sdate,
convert(time,sta_datetime) as S_Time,
Moto.province_id,
Moto.ne_id,
bss_cssr cssrv1,
tchtc traffic,
cssr cssrv2,
hosr_v2 hosrv2,
dropc dcr,
dcr_v2 dcrv2,
cavl calvol,
hansr hosr,
tchblor tchblr,
sdcchbr sdcchblkr
from OracleDBLink
where
convert(varchar(10),sta_datetime,111) = CONVERT(varchar(10), getdate()-1,111)
and ((bss_cssr <=95) or (dropc>=3) or (hansr<=95)) and cavl>=50
it seem to be OK get the result as I Want.
But I can Put it in the View.
I Want to creat a job to do it everytime
|
|
|
|
|
Oracle has two major temporal types, Date and Timestamp, where Timestamp has higher precision but less functionality.
The easiest way to get a date without the time component is Trunc(MyDate)
|
|
|
|
|
Hi,
I have below date text and I want to know how can I convert it to valid MySQL datetime which is yyyy-mm-dd HH:mm
Nov 20 2015 10:51AM
Nov 20 2015 10:16PM
Nov 20 2015 10:01AM
Nov 20 2015 8:43PM
Nov 20 2015 8:04PM
Nov 20 2015 5:49PM
Nov 20 2015 5:38PM
Nov 20 2015 5:23PM
Nov 20 2015 5:03PM
Nov 20 2015 4:57PM
Nov 20 2015 2:10PM
Nov 20 2015 1:51PM
Nov 19 2015 12:24AM
Nov 19 2015 11:56AM
Nov 19 2015 11:32PM
Nov 19 2015 11:27PM
Nov 19 2015 10:15AM
Nov 19 2015 10:12PM
How can I do this please?
Thanks,
Jassim[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
This should work:
SELECT DATE_FORMAT(STR_TO_DATE('Nov 20 2015 10:51AM', '%b %d %Y %h:%i%p'), '%Y-%m-%d %H:%i'); #Returns 2015-11-20 10:51
SELECT DATE_FORMAT(STR_TO_DATE('Nov 20 2015 8:43PM', '%b %d %Y %h:%i%p'), '%Y-%m-%d %H:%i'); #Returns 2015-11-20 20:43
-NP
Never underestimate the creativity of the end-user.
|
|
|
|
|
Wow doesn't MySQL have the convert function?
SELECT CONVERT(DATETIME,'Nov 20 2015 8:43PM')
Is the SQL Server method, so simples!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
It does have a CONVERT method but it won't work with that format of text dates. That was the first thing I tried.
-NP
Never underestimate the creativity of the end-user.
|
|
|
|
|
I just got handed a challange:
Create a program to knead stellar data into something visual.
I know this is redundant, as the tools already exist, but I'm between jobs and need something to do.
So I have access to the data, which is a HUGE csv file. said CSV dataset keeps crashing, excel and access, so I need some local, "portable"/deployable and free database technology. Since I want some scalability, and decleared datatypes, using a CSV file isn't feasable.
My first thought is a sql server, but they're not real user friendly if I want to distribute the software.
Anyone have any suggestions?
Please explain the benefits of the technology and not just name thibgs
Thanks!
|
|
|
|
|
How big is this file?
Both in bytes and in rows.
|
|
|
|
|
|
|
Apparently it's not the case (or not yet?) but I was under the impression that SQL Compact was deprecated. Did MS change their mind or am I confusing it with something "similar"?
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
I don't know, I have not used it recently.
|
|
|
|
|
(Almost) Any database can handle that.
Take a look at SQLite[^] for minimal installation and configuration.
Or SQL Server Compact edition as already mentioned, if you want to be able to upgrade to a larger version later on.
There are several inbetween versions of SQL-Server, there's an ok overview here[^]
|
|
|
|