sql - Calculate working shift giving current datetime in sybase -

-

i need sql script in sybase or @ least ansi sql giving current datetime, can current working shift.

  • working shift '1' begins @ 08:00 , ends @ 15:30
  • working shift '2' begins @ 15:30 , ends @ 23:00
  • working shift '3' begins @ 23:00 , ends @ 08:00am of next day

i having trouble third shift, because of change between 1 day , next day

set  @fechaactual = convert(datetime, 'jun 11 2015 11:00am', 100) --getdate()  set @horacomienzoturno1 = convert(datetime,convert(varchar, @fechaactual, 101) + " 08:00:00 am") set @horafinturno1 = convert(datetime,convert(varchar, @fechaactual, 101) + " 03:29:59 pm") set @horacomienzoturno2 = convert(datetime,convert(varchar, @fechaactual, 101) + " 03:30:00 pm") set @horafinturno2 = convert(datetime,convert(varchar, @fechaactual, 101) + " 10:59:59 pm") set @horacomienzoturno3 = convert(datetime,convert(varchar, @fechaactual, 101) + " 11:00:00 pm") set @horafinturno3 = convert(datetime,convert(varchar, @fechaactual, 101) + " 07:59:59 am")  if @fechaactual >= @horacomienzoturno1 , @fechaactual <= @horafinturno1 begin     select 1 turno, @fechaactual fechaactual end  if @fechaactual >= @horacomienzoturno2 , @fechaactual <= @horafinturno2  begin     select 2 turno, @fechaactual fechaactual end  if @fechaactual >= @horacomienzoturno3 , @fechaactual <= @horafinturno3  begin     select 3 turno, dateadd(dd, -1, @fechaactual) fechaactual end

i have no sybase here, cannot try it. think need datepart function. function gets hours, or minutes datetime value, able check without thinking in days.

i did following changes:

  • i changed code show how works (maybe spelling not right)

  • i changed last condition or, because it´s impossible last shift worker, have hour > 23 , < 9 @ same time ;-)

hope may you. (sorry if doesn´t compile, it´s few years since don´t play sybase).

set  @fechaactual = datepart("hhmi",convert(datetime, 'jun 11 2015 11:00am', 100))  set @horacomienzoturno1 = datepart("hhmi",convert(datetime,convert(varchar, @fechaactual, 101) + " 08:00:00 am")) set @horafinturno1 = datepart("hhmi",convert(datetime,convert(varchar, @fechaactual, 101) + " 03:29:59 pm")) set @horacomienzoturno2 = datepart("hhmi",convert(datetime,convert(varchar, @fechaactual, 101) + " 03:30:00 pm")) set @horafinturno2 = datepart("hhmi",convert(datetime,convert(varchar, @fechaactual, 101) + " 10:59:59 pm")) set @horacomienzoturno3 = datepart("hhmi",convert(datetime,convert(varchar, @fechaactual, 101) + " 11:00:00 pm")) set @horafinturno3 = datepart("hhmi",convert(datetime,convert(varchar, @fechaactual, 101) + " 07:59:59 am"))  if @fechaactual >= @horacomienzoturno1 , @fechaactual <= @horafinturno1 begin     select 1 turno, @fechaactual fechaactual end  if @fechaactual >= @horacomienzoturno2 , @fechaactual <= @horafinturno2  begin     select 2 turno, @fechaactual fechaactual end  if @fechaactual >= @horacomienzoturno3 or @fechaactual <= @horafinturno3  begin     select 3 turno, dateadd(dd, -1, @fechaactual) fechaactual end

edit added "mi" datepart() pattern, manage minutes


Comments

Post a Comment

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

-
i'm running nodejs 0.12.3 - gulp 3.10.8 , gulp-nodemon 2.0.3. gulpfile.js : gulp.task('serve', ['build'], function() { gulp.start('fb-flo'); nodemon({ script: paths.server, env: { 'node_env': 'development' }, // env: { 'node_env': 'production' }, execmap: { 'js': 'node_modules/babel/bin/babel-node --stage 1' //es7 cote server }, delay: '0ms', watch: ['src/shared/', 'src/server/'], ignore: ['src/shared/components'], tasks: function (changedfiles) { var tasks = []; changedfiles.foreach(function (file) { if (path.extname(file) === '.jsx' && !~tasks.indexof('bundlejs')) tasks.push('bundlejs'); if (path.extname(file) === '.less' && !~tasks.indexof('compileless')) tasks.push('compileless'); }); return tasks; } ...
Read more

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

-
i trying make simple python program opening list of webpages user manually download reports site. don't have previous experience preparing exe files.. , i'm in learning process python coding. of done on windows 7 x64 this python code: #!c:/python34/python.exe -u splinter import * import time import os import csv #---------------------------------- raporty = [] open('../raporty.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') raporty.append(r) #--not implemented yet zmienne = [] open('../zmienne.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') zmienne.append(r) print("start") browser = browser(...
Read more

javascript - oscilloscope of speaker input stops rendering after a few seconds -

-
the following script reads audio user's microphone , renders oscilloscope on html canvas. the source taken example of mozilla developer network: visualizations web audio api and here fiddle: http://jsfiddle.net/b7j8pktp/ mozgetusermedia (note: code has no fork mechanism different browsers: works firefox) it works fine few seconds , stops rendering. whereas works totally stable: http://mdn.github.io/voice-change-o-matic/ the problem can reduced following code. microphone activation icon (next the address bar in firefox) disappears after 5 seconds: navigator.mozgetusermedia({audio: true}, function() {}, function() {} ); ( http://jsfiddle.net/b7j8pktp/2/ ) this known bug in firefox. take stream getusermedia call , hook window so: navigator.mozgetusermedia({audio: true}, function(stream) { window.stream = stream; // rest of code }, function err() { // handle error }); hopefully can fixed soon. problem we're f...
Read more